Forum Discussion
Excel file Worksheets combined (all tabs)
I have a file that needs to be combined into one worksheet. There are multiple worsheet tabs that need to be combined into one data set. Each tab has the same column headings. Each row is unique. A worksheet/tab represents a day of tracking information. I want to analyze all data across these worksheet/tabs in a pivot table. Is this possible?
2 Replies
An alternative could be Power Query. In the attached file you can add worksheets with blue dynamic tables for each day. The formatting into a dynamic table is done by clicking in any cell of the (not yet dynamic) table and ctrl+T.
Then you can click in any cell of the green result table and right-click with the mouse and then select refresh. The green table can be used as the basis for e.g. a pivot table.
The Query works with the assumption that all blue dynamic tables contain "Tabelle" in their name. In the screenshot you can see the highlighted name of the table which contains "Tabelle". When you open the attached file the name could show "Table6" instead of "Tabelle6" if you work with english Excel. If so all table names have to contain "Table" (because of a filter that is applied in the Query).
- how about online tool？
