Hi All,
So i have been sent unstructured data which i need in a nice format to analyse. I have attached what i would like the data to look like (the part at the bottom of the image).
I don't know if there is any code which would help in getting my data to look in that format. Appreciate any help
Thank you!
It looks like you want the Power Query's/Get and Transform's unpivot command: https://support.microsoft.com/en-us/...5-f588221c7098
Originally Posted by shg
Hi chouz06
Welcome to the Forum...
if there is any code which would help in getting my data to look in that format.
Please Login or Register to view this content.
Last edited by sintek; 11-28-2021 at 04:49 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks