LinkBack URL
About LinkBacks
I have a table similar to TABLE A (but much bigger).
I want to convert the table to a format like TABLE B.
Any ideas on how to do this?
Skjermbilde 2024-02-01 kl. 21.17.23.png
I have a table similar to TABLE A (but much bigger).
I want to convert the table to a format like TABLE B.
Any ideas on how to do this?
Skjermbilde 2024-02-01 kl. 21.17.23.png
Copy and paste special and tag the transpose checkbox
Attachment 858031
Thanks, maybe I dont understand what you mean.
Will not transpose just switch rows to columns, i.e. I do not get one unique line for each country/city combination?
Do you have the Excel file for me, so i can see what you mean?
Perhaps trying the following will help.
1. Convert columns C:F into an Excel table
2. Load the Excel table into Get & Transform using From Table/Range on Data tab
3. Select all columns
4. Unpivot selected columns
Note that you will have to add column headers.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks