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

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.

Consolidate_19101023.yxmd