Display row duplicates on one line

[NikSTHF]

Hi folks,

Trying to figure out a way to get an end result to show only a single line of data where the source has duplication of names but separate data.

Source data is displayed link the following;

Person ID	Person	Status 1	Status 2	Status 3	Status 4
A1234	Matt Damon	00:04:32	00:00:00	00:00:00	00:31:12
A1234	Matt Damon	00:00:00	00:21:16	01:12:13	00:00:00
A1235	Tom Cruise	00:12:00	01:31:10	16:02:48	00:09:41
A1236	Tom Hardy	00:00:00	00:00:00	00:00:00	00:00:00

I need it to do;

Person ID	Person	Status 1	Status 2	Status 3	Status 4
A1234	Matt Damon	00:04:32	00:21:16	01:12:13	00:31:12
A1235	Tom Cruise	00:12:00	01:31:10	16:02:48	00:09:41
A1236	Tom Hardy	00:00:00	00:00:00	00:00:00	00:00:00

Essentially combining the two duplicate lines into a single row that can then be used to join to some additional data. If I try this standalone then it just duplicates all joined data.

Any help would be great.

Thanks,

NikSTHF

[NickC · Accepted solution]

Hello,

Try using the Summarize tool

Group By Person ID

Group By Person

Max Status 1

Max Status 2

Max Status 3

Max Status 4

Thanks,

Nick

[NikSTHF]

Well aren't you an absolute gemstone. I sat there for ages trying that and moved on to Crosstabs and everything. Cheers buddy!