Hi,
I have the following table part way through a Powerquery:
And need to transpose it to something along these lines:
In effect, I want to group by the Index column and then spread the other rows across sufficient columns. I can't say at this stage how many columns will be required.
Any ideas gratefully accepted (even if the answer is put it into a sheet and run some VBA against it! - hope not).
Regards
I have the following table part way through a Powerquery:
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
2 | Input: | ||||
3 | Index | DP Group 1 | DP Group 2 | ||
4 | 23 | DP2 | null | ||
5 | 34 | DP11 | DP8 | ||
6 | 34 | DP11 | -DP11 | ||
7 | 34 | DP11 | DP9 | ||
8 | 34 | DP11 | DP10 | ||
9 | 35 | null | DP2 | ||
10 | 35 | null | DP3 | ||
Sheet1 |
And need to transpose it to something along these lines:
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
12 | Output | ||||||||||
13 | Index | DP Group 1.1 | DP Group 1.2 | DP Group 1.3 | DP Group 1.4 | DPGroup2.1 | DPGroup2.2 | DPGroup2.3 | DPGroup2.4 | ||
14 | 23 | DP2 | |||||||||
15 | 34 | DP11 | DP11 | DP11 | DP11 | DP8 | -DP11 | DP9 | DP10 | ||
16 | 35 | DP2 | DP3 | ||||||||
Sheet1 |
In effect, I want to group by the Index column and then spread the other rows across sufficient columns. I can't say at this stage how many columns will be required.
Any ideas gratefully accepted (even if the answer is put it into a sheet and run some VBA against it! - hope not).
Regards