Forum Discussion
How to make one pivot with data from different sheet
Do you want some data clean or ETL (extract trasform and load)?
What is the expected result?
- DropjeMar 29, 2023Copper Contributor
the STAT sheet is a draft where I have created different pivot form the different sheet but now I have 15 pivot and for the chart I had to make an other schedule with all the data from the pivot. Is not useful.
The result if is possible is to have one pivot, as all the sheet have the same column name, where I can have a filter that allow me to change the section (A, AA; AB, AC etc) and the list of the different data form the Current status column. from this pivot I can make the chart.
I have tried to join all the sheet in one pivot (you can see the starting of the pivot under the 15 different) but I don't know how to merge all the data in one
- peiyezhuMar 29, 2023Bronze Contributorhave tried to join all the sheet in one pivot
Yes,I know you want to merge all datas to a list which can back support one pivot analysis table analysis.
I supposed you know the format of the backend list I mentioned above which is transfered from the sheet STAT.
But now,you mentioned multiple raw sheets,I am lost.
If you provide some raw datas and expected result in detail,it maybe helpful to understand what you want to do.- DropjeMar 30, 2023Copper Contributor
sorry I didn't explain clear.
In the file I have these sheets where all the data are updated
I am trying to have one pivot like this, where I can have the total from all the sheet + filter for the sheet
at end I am trying to have something like this. I have done wit getpivotdata from the 16 different pivot but I think it will be better to have directly one pivot