Forum Discussion
Transform data to fix duplicate rows into columns
I have a spreadsheet that is an output from a separate system, which does not allow me to configure the output in any way. I need to modify the output in Excel or a related tool (macro, BI, etc.) ...
I may need to see a larger sample, but for what you've provided, perhaps this:
=UNIQUE(TOROW(data,,1),1)