Hi everyone,
I'm trying to turn all my rows under F1 column into headers and having a hard time figuring out how to do so.
Original Data:
F1 F2 F3 F4
Tax Owner O1 O1 O2
Tax Code 001 001 002
Entity Name A B C
I want it to look like this:
Tax Owner Tax Code Entity Name
O1 001 A
O1 001 B
O2 002 C
I tried transposing and that doesn't seem to work. Any help would be greatly appreciated, thanks!
Solved! Go to Solution.
Thank you so much! Really appreciate it.
Thanks- very helpful