Forum Discussion
Unpivot table with different fields
Hello everybody, I have searched and read some posts about pivot and unpivot tables; however, my data is a bit differnet and very ugly, I need some help on the this: Table I got: ID Mont...
Hi Anonymous
Yes, you might have to replace the column names in the code.
You can also delete the last steps and do the expansion manually so you can see what's actually there.
Hi ImkeF ,
I found the issue that the column "Team/Scores/Munites" in my read data is not in the third column, so when I expand the table, it showed null as the order is wrong.
Thank you for the brilliant answer!