Forum Discussion
Solved
How can Excel achieve this transform function?
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 X...
Hello!
Attached is an excel file, I did this with 3 different ways power query, a pivot table or dynamic formulas.
Hope it works.
Hello!
Attached is an excel file, I did this with 3 different ways power query, a pivot table or dynamic formulas.
Hope it works.
- Appreciated! Learned a lot!
