Forum Discussion
Switch row to column on Data table
Hi Everyone, I have a data table wherein i need to transponse the row to column but my challenge is, it has more than 2 lacs records connected with SQL. Is this possible to transpose in Power...
Vijay_A_Verma Thank you so much for the reply however how could i able to bring all my 2 lacs records into this query. That is my challenge.
Get your data in PQ from your source. Then follow the below steps
Transform menu - Use headers as first row
Transform menu - Transpose
If you are still facing issue in getting data into PQ, please provide details of your source and problem being faced.