Feb 07 2022 08:20 AM
Is there a way to easily transform the first table into the second one in Excel? Thanks.
A | B | |
X1 | Y1 | |
X1 | Y2 | |
X1 | Y3 | |
X2 | Y4 | |
X2 | Y5 | |
X2 | Y6 | |
X2 | Y7 | |
X2 | Y8 | |
X3 | Y9 | |
X3 | Y10 | |
X3 | Y11 | |
X3 | Y12 | |
X3 | Y13 | |
X1 | Y14 | |
X1 | Y15 | |
X1 | Y16 | |
X2 | Y17 | |
X2 | Y18 | |
X2 | Y19 | |
X2 | Y20 | |
X2 | Y21 | |
X3 | Y22 | |
X3 | Y23 | |
X3 | Y24 | |
X3 | Y25 | |
X3 | Y26 |
A | B | |||||||||
X1 | Y1 | Y2 | Y3 | Y14 | Y15 | Y16 | ||||
X2 | Y4 | Y5 | Y6 | Y7 | Y8 | Y17 | Y18 | Y19 | Y20 | Y21 |
X3 | Y9 | Y10 | Y11 | Y12 | Y13 | Y22 | Y23 | Y24 | Y25 | Y26 |
Feb 09 2022 09:41 PM
Solution
Hello!
Attached is an excel file, I did this with 3 different ways power query, a pivot table or dynamic formulas.
Hope it works.
Feb 10 2022 07:45 AM
Feb 09 2022 09:41 PM
Solution
Hello!
Attached is an excel file, I did this with 3 different ways power query, a pivot table or dynamic formulas.
Hope it works.