Forum Discussion

Copper Contributor

Mar 28, 2023

How to make one pivot with data from different sheet

I have tried to make one pivot from different sheet in excel but I didn't understand how can do that in this file in the Sheet STAT I have tried to import in one pivot all the data but now don't know...

00_Renov_doc_list.xlsx16.3 MB

Charting

excel

Formulas and Functions

peiyezhu

Bronze Contributor

Mar 30, 2023

https://support.microsoft.com/en-us/office/consolidate-multiple-worksheets-into-one-pivottable-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5

hope helpful

Dropje

Copper Contributor

Mar 31, 2023

I have seen that before that's why ask because I have tried but as you can see in the shared file under all the single pivot I don't know how merge all the information because are still separated in the pivot items, now I have imported all the sheets but I don't know how proceed. STAT wip 2 sheet

00_Renov_doc_list.xlsx19.1 MB

peiyezhu
Bronze Contributor
Mar 31, 2023
Dropje

I guess you need convert from RowTable.xlsx to output.xlsx before pivotable.
ouput.xlsx19 KB
RawTables22.xlsx11 KB
- Dropje
  Copper Contributor
  Apr 01, 2023
  peiyezhu
  Sorry I don't understand, I need to have one sheet with all the data in one place?
  
  I have seen you example but I don't understand how can I merge the differente table in one pivot
  - peiyezhu
    Bronze Contributor
    Apr 01, 2023
    how can I merge the differente table in one pivot
    
    before pivotable, you'd better merge all sheets to one with addtional column sheet name.
    after that,you can build the pivottable on this new sheet which enable you filter by sheet name.