Forum Discussion
Two different pivot tables into one
You may Power Query your source data and return by it as many tables as needed. Plus PivotTable from data model if necessary, but I guess all tables could be generated by PQ only.
Can please explain?? PLEASE
Does you version of Excel supports Power Query and do you have at least some experience with it?
- Yes, it support Power Query... I know only basic thing..
If these two tables are for one customer at a time, you need to define somewhere which customer to select. That could be a named cell or like which you may query and use as parameter.
Query source data, do some initial transformations in this query if necessary and filter on customer taken from previous query. Keep this query as connection and load to data model.
Create one more query as reference on above, keep only customer info columns, transpose it and return to Excel as first table in sheet.
Make another reference and transform data for the second table or create from data model PivotTable in Excel sheet. What's better and more suitable depends on concrete data.
Something lie this.