Forum Discussion

pudel's avatar
pudel
Regular Visitor
5 years ago
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 ...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    5 years ago

    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.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

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.