I am trying to transform a spreadsheet in SHEET1 that looks like this:
COLUMN1
A
A
A
B
B
B
B
C
I want it to be in SHEET2 like this
ROW Header: A B C
I am basically trying to:
Get unique items in first column Transpose and promote these items as column headers
I need the output table in SHEET 2 to dynamically update each time. No VBA. for example if I add D to SHEET 1, D will automatically update on SHEET 2 Header.... A B C D
COLUMN1
A
A
A
B
B
B
B
C
D
I want it to automatically update in SHEET2 like this
ROW Header: A B C D