I found a partial solution in a thread named convert-data-from-vertical-to-horizontal-based-on-column-a.
The post covers most of my problem, but I need a slightly different output column. I would like all the values to be concatenated with a "|" between them.
This is my input:
TT Test
Assembly Final
Assembly Preliminary
Assembly Set out
Coating Application
Coating Blast/Prep
Coating Coating
Coating Final
I would like a table that shows:
Column 1 Column 2
Assembly |Final|Preliminary|Set out
Coating |Application|Blast/Prep|Coating|Final
Thanks for your help!
Bookmarks