Forum Discussion
Solved
Restructure table: create row entries based on column value
I'm trying to create a revenue reporting for multiple stores. The source data is queried from a web-api for each store seperately and structured like: Date Invoice# Customer PayMethod Total ...
Select the columns from Date to Total. Right-click the header and choose Unpivot Other Columns.
I think that'll work. Let me know how you get on.
Select the columns from Date to Total. Right-click the header and choose Unpivot Other Columns.
I think that'll work. Let me know how you get on.