I have a table with the following information:ID; A; B; C1; A; B; C2; A; B; C3; A; B; CI want to turn these into the following table:1; A1; B1; C2; A2; B2; CAfter googeling for a couple of hours, i can't seem to find the solution. Is there a easy solution to this?Thank you in advance!
With kind regards,
Go to Solution.
In the Query Editor,, Select the Letter Columns>>>Go to Transform Tab>>> Unpivot
View solution in original post
You will get below. Delete extraneous columns and rename as necessary
Awesome! Works like a charm! Thank you!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!