Consolidating data in mutiple fields

[LeoMessi]

Hello community, 

Here is my data: 

ID	Cat A	Cat B	Cat C
100	A
102		B
104	A
100		B
102			C
104		B
104			C

I want to consolidate my data in the following format:

ID	Cat A	Cat B	Cat C
100
102
104

[JosephSerpis · Accepted solution]

Hi @LeoMessi i'm assuming you want to remove the blanks and keep the cells with values therefore I mocked up an approach which showcases how to do this.

[LeoMessi]

Thank you, this worked!