Two different pivot tables into one

%3CLINGO-SUB%20id%3D%22lingo-sub-1918253%22%20slang%3D%22en-US%22%3ETwo%20different%20pivot%20tables%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918253%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EI%20have%20a%20customer%20list%20for%20my%20business.%3C%2FP%3E%3CP%3EThis%20list%20includes%20A1%3A%20Name%2C%20B1%3A%20Address%2C%20C1%3APhone%20Number%20etc...%20(This%20is%20first%20part%20of%20my%20table)%3C%2FP%3E%3CP%3EThen%20the%20values%20start%3A%26nbsp%3B%20K1%3A%20Number%20of%20Unit%3B%26nbsp%3B%20L1%3A%20Sales%2C%20L1%3AAnnual%20Consumption%20etc...%26nbsp%3B%20(This%20is%20the%20second%20part%20of%20my%20same%20table)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20show%20the%201.%20part%20on%20the%20top%20and%20the%202.%20part%20on%20the%20pivot%20table%20at%20the%20same%20time.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20bring%20them%20together%20in%20one%20pivot%20table%20sheet%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22p.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235190i1F435479A5B0FE36%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22p.PNG%22%20alt%3D%22p.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20helps..%3F%3F%3C%2FP%3E%3CP%3EI%20am%20using%20Microsoft%202019%20(window%20operating%20system)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1918253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1918284%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20different%20pivot%20tables%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20Power%20Query%20your%20source%20data%20and%20return%20by%20it%20as%20many%20tables%20as%20needed.%20Plus%20PivotTable%20from%20data%20model%20if%20necessary%2C%20but%20I%20guess%20all%20tables%20could%20be%20generated%20by%20PQ%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1918343%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20different%20pivot%20tables%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918343%22%20slang%3D%22en-US%22%3EHow%20can%20i%20do%3F%3CBR%20%2F%3ECan%20please%20explain%3F%3F%20PLEASE%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1918521%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20different%20pivot%20tables%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918521%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20you%20version%20of%20Excel%20supports%20Power%20Query%20and%20do%20you%20have%20at%20least%20some%20experience%20with%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello Everyone,

I have a customer list for my business.

This list includes A1: Name, B1: Address, C1:Phone Number etc... (This is first part of my table)

Then the values start:  K1: Number of Unit;  L1: Sales, L1:Annual Consumption etc...  (This is the second part of my same table)

 

I want to show the 1. part on the top and the 2. part on the pivot table at the same time. 

How can I bring them together in one pivot table sheet? 

p.PNG

 

Please helps..??

I am using Microsoft 2019 (window operating system)

5 Replies
Highlighted

@Zan_Hanifee 

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.

Highlighted
How can i do?
Can please explain?? PLEASE
Highlighted

@Zan_Hanifee 

Does you version of Excel supports Power Query and do you have at least some experience with it?

Highlighted
Yes, it support Power Query... I know only basic thing..
Highlighted

@Zan_Hanifee 

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.