how do I make a data that look like below picture and change it to "to be"
The picture will explain. i have a very long row of data that need to move in to 1 row, is there a easy way todo without copying and transpose row by row
1 Answer
You can use Power Query to get the result:
Select Range and go to Data- From Table/Range (uncheck "My table has a header"):
Select all Columns- Go to Transform- Unpivot Columns- Remove column Atribute:
Close and load data:
