• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unpivot bad dataset that contains headings and records

M

matt-gilbert

Member
Hi all, I have a bad dataset that contains headers and records (looks like a pivot table in compact form). I would like to unpivot and create new columns for the different headers (in example attached this is Country, State & City). I have added a column called "Type" where I have assigned type to each item in dataset and then tried unpivoting and transforming without success. Any help would be appreciated. Thanks in advance, Matt
 

Attachments

  • Test2.xlsx
    16 KB · Views: 4
See attached, result table at cell N2.
No attempt made to make it 'elegant'!
 

Attachments

  • Chandoo58436Test2.xlsx
    19.5 KB · Views: 3
Thanks so much p45cal. I thought it might be easy but it looks quite complicated (to me). I'll try and learn how you've done it! Thanks again
 
You must log in or register to reply here.
Back
Top