Hi, i have the below CSV file that when i download from our system has all reports on the one sheet. How can i load convert this to each report being on a different sheet/table in power query. A small snippet of the data below.
Note the headers of each report i have highlighted.
Note the headers of each report i have highlighted.
Department Profit DSA Report2023090880713368.csv | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Company_Name | Branch_Name | Department_Name | Original_MTD_Budget_Amt | MTD_Budget_Amt | MTD_Actual_Amt | MTD_Variance_Amt | ||
2 | OSPK Pty Ltd | PARK KIA | New Vehicles | 42197 | 42197 | -25611.72 | 67808.72 | ||
3 | OSPK Pty Ltd | PARK KIA | Used Vehicles | -4064 | -4064 | -85187.18 | 81123.18 | ||
4 | OSPK Pty Ltd | PARK KIA | Aftermarket | 29654 | 29654 | 23519.4 | 6134.6 | ||
5 | Source | Company_Key | Company_Name | Branch_Key | Branch_Name | Department_Order | PAndL_View_Order | ||
6 | Sales/COGS | 1 | OSPK Pty Ltd | 1 | PARK KIA | 6 | 1 | ||
7 | Sales/COGS | 1 | OSPK Pty Ltd | 1 | PARK KIA | 7 | 1 | ||
8 | Source | Company_Key | Company_Name | Branch_Key | Branch_Name | Section_ID | Account_Group_ID | ||
9 | Expense/Income | 1 | OSPK Pty Ltd | 1 | PARK KIA | 6 | |||
10 | Expense/Income | 1 | OSPK Pty Ltd | 1 | PARK KIA | 6 | |||
11 | Expense/Income | 1 | OSPK Pty Ltd | 1 | PARK KIA | 6 | 61 | ||
12 | Expense/Income | 1 | OSPK Pty Ltd | 1 | PARK KIA | 6 | 61 | ||
13 | Source | Company_Key | Company_Name | Branch_Key | Branch_Name | Department_Order | Department_ID | ||
14 | Statistic | 1 | OSPK Pty Ltd | 1 | PARK KIA | 6 | 6 | ||
15 | Statistic | 1 | OSPK Pty Ltd | 1 | PARK KIA | 7 | 7 | ||
16 | Statistic | 1 | OSPK Pty Ltd | 1 | PARK KIA | 10 | 10 | ||
17 | Statistic | 1 | OSPK Pty Ltd | 1 | PARK KIA | -1 | -1 | ||
18 | Statistic | 1 | OSPK Pty Ltd | 1 | PARK KIA | 6 | 6 | ||
19 | Statistic | 1 | OSPK Pty Ltd | 1 | OSBORNE PARK KIA | 7 | 7 | ||
Department Profit DSA Report202 |