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 |
Solved! Go to 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.
Thank you, this worked!