I am hoping someone could advise me on the below - or just any ideas that could help.
I want to do the opposite of a pivot table of sorts, my data is summarised and I need to break it down into singles.
The reason I need to break it into singles, is I need to plan loads of say 40 with the potential for each load to have a remainder - hence the need for singles to accurately calculate.
I already have the macro to split the data from singles (I think with a few amendments) but I need to get to singles to test it works!
Here is what I have and what I want:
Is there a function in excel to reverse a pivot table?
Thank you for your time
Sara
I want to do the opposite of a pivot table of sorts, my data is summarised and I need to break it down into singles.
The reason I need to break it into singles, is I need to plan loads of say 40 with the potential for each load to have a remainder - hence the need for singles to accurately calculate.
I already have the macro to split the data from singles (I think with a few amendments) but I need to get to singles to test it works!
Here is what I have and what I want:
New Wave File Template Aug 2021.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Priority | Store Number | Store Name | Sum of Pallet Total | Priority | Store Number | Store Name | Sum of Pallet Total | |||
2 | 1 | 114 | Jersey | 2 | 1 | 114 | Jersey | 1 | |||
3 | 3 | 865 | Broadstairs | 4 | 1 | 114 | Jersey | 1 | |||
4 | 4 | 800 | Canterbury | 11 | 3 | 865 | Broadstairs | 1 | |||
5 | 5 | 265 | Ashford | 6 | 3 | 865 | Broadstairs | 1 | |||
6 | 23 | 3 | 865 | Broadstairs | 1 | ||||||
7 | 3 | 865 | Broadstairs | 1 | |||||||
8 | 4 | 800 | Canterbury | 1 | |||||||
9 | 4 | 800 | Canterbury | 1 | |||||||
10 | 4 | 800 | Canterbury | 1 | |||||||
11 | 4 | 800 | Canterbury | 1 | |||||||
12 | 4 | 800 | Canterbury | 1 | |||||||
13 | 4 | 800 | Canterbury | 1 | |||||||
14 | 4 | 800 | Canterbury | 1 | |||||||
15 | 4 | 800 | Canterbury | 1 | |||||||
16 | 4 | 800 | Canterbury | 1 | |||||||
17 | 4 | 800 | Canterbury | 1 | |||||||
18 | 4 | 800 | Canterbury | 1 | |||||||
19 | 5 | 265 | Ashford | 1 | |||||||
20 | 5 | 265 | Ashford | 1 | |||||||
21 | 5 | 265 | Ashford | 1 | |||||||
22 | 5 | 265 | Ashford | 1 | |||||||
23 | 5 | 265 | Ashford | 1 | |||||||
24 | 5 | 265 | Ashford | 1 | |||||||
25 | 23 | ||||||||||
Sheet6 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1:D5 | A1 | ='Stoke 1 Pallets'!F6 |
D6 | D6 | =SUM(D2:D5) |
I25 | I25 | =SUM(I2:I24) |
Is there a function in excel to reverse a pivot table?
Thank you for your time
Sara