Forum

Notifications
Clear all

Unpivot Table with multiple headers and columns

3 Posts
3 Users
0 Reactions
72 Views
(@richy89)
Posts: 1
New Member
Topic starter
 

Hi All,

Could someone please help me change data in a table to rows? I have provided table and desired output in attached file.
The table format is provided by a third party and cannot be changed so I have no option but come up with a way to manually copy and paste for now. What I have showed in the file is a sample only. There is a lot more data in similar complex format that I have excluded.

Thanks

 
Posted : 25/05/2023 6:34 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Rik,

Welcome to our forum! Please try uploading again. Be sure to click the 'start upload' button and wait for the grey check mark beside the file size before submitting your reply.

Mynda

 
Posted : 25/05/2023 7:00 pm
(@keebellah)
Posts: 373
Reputable Member
 

Hi Rik,
Aside from uploading the file I also suggest you update your profile telling us which Excel (Office) version you're using

 
Posted : 26/05/2023 7:40 am
Share: