Forum Discussion
Solved
Help with loading budgeting files
I have an Excel file with a many sheets in the same format. How do I load and combine the sheets into this format The sample file is here Thanks
I have managed to get what I wanted by
1. Load all the sheets, 2 in this case, as one base table
2. Create a header table from the base table by retaining only the header rows and pivoting by Dept and Name
3. Create the data table from the base table by filtering off header records and merging the table with the header table above
I have managed to get what I wanted by
1. Load all the sheets, 2 in this case, as one base table
2. Create a header table from the base table by retaining only the header rows and pivoting by Dept and Name
3. Create the data table from the base table by filtering off header records and merging the table with the header table above