Hello!
For columns with the same value, how do I consolidate the values under
those identical columns into one instance of the column name?


I have this:
Facility Plant 1 Plant 1 Plant 1 Plant 2 Plant 2 Plant 2
App app 1 app2 app 4 app 3 app 5 app 7

I would like this:
Facility Plant 1 Plant 2
Apps app 1 app 3
app 2 app 5
app 4 app 7

And this would be even better:
Facility Plant 1 Plant 2
Apps
App 1 x
App 2 x
App 3 x
App 4 x
App 5 x
App 6
App 7 x


Thanks!
--
Aidan