O Oscarr Member Jun 20, 2019 #1 hi how to use power query to TRANSPOSE data ? and Data Value will follow date.. please review attached file Thanks Attachments sample.xlsx 12.7 KB · Views: 7
hi how to use power query to TRANSPOSE data ? and Data Value will follow date.. please review attached file Thanks
chirayu Well-Known Member Jun 20, 2019 #2 Why do you want PowerQuery? You could just add the table as a range to a PivotTable and use it that way. Attached Attachments Copy of sample.xlsx 24.4 KB · Views: 6
Why do you want PowerQuery? You could just add the table as a range to a PivotTable and use it that way. Attached
O Oscarr Member Jun 20, 2019 #3 chirayu said: Why do you want PowerQuery? You could just add the table as a range to a PivotTable and use it that way. Attached Click to expand... thanks
chirayu said: Why do you want PowerQuery? You could just add the table as a range to a PivotTable and use it that way. Attached Click to expand... thanks