Forum Discussion
How to Pivot Multiple Values to Row Column Header
I feel like I'm running at a blank, how can I convert this data set so that only the first 11 rows are column headers. I have rows of this information but only "Date" to "Prime Firm" are needed for c...
Hi Anonymous ,
See the below,for an example:
base table:
1. Transform data:
transpose table:
after transpose table:
2.Then use the first row as header:
3.After apply and then delete other column you do not need.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien