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.) ...
=DROP(TOROW(REDUCE("",SEQUENCE(COLUMNS(A1:F1)),LAMBDA(x,y,VSTACK(x,UNIQUE(CHOOSECOLS(A1:F24,y)))))),,1)
You can try this formula if you work with Office 365 or Excel for the web.