How to summarize on few columns but bring other related values to the rows

[belurrashmi]

Hi 

I have a table

Release	Project	Application	Resolved date	Sheet number	Build
R1	P1	APP1	10/28/2016	1	1
R2	P1	APP1	10/29/2016	2	2
R1	P2	APP1	10/30/2016	3	3
R1	P1	APP1	10/31/2016	4	4
R2	P1	APP2	11/01/2016	5	5
R1	P2	APP2	11/02/2016	6	6
R2	P1	APP2	11/03/2016	7	7
R1	P2	APP2	11/04/2016	8	8

I would like to group by first three columns and find the latest resolved date & display corresponding sheetnumber & build.

What is the best way to do that?

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.