Hi there
When I export some data from one of our systems the data isn?t in a useable format. Is there a way I can tidy this up and make it easy to reference the Username (User1, User2, User 3) and the skill levels that belong to each? I feel like this could be possible with get&transform but not properly used it before
A final layout like the one shown in the attachment from column F would be perfect
Any help would be very much appreciated!
Thanks
Your profile indicates XL2010. I don't thing Power Query was already available.
Oh I haven't used this forum in years! Have updated... now using latest version of Office
Re: Tidy up data export into usable format
just for fun with Power Query
U1 U2 U3 User1 User2 User3 CLIENT1 Standard CLIENT1 Standard CLIENT2 Standard CLIENT2 Standard CLIENT3 Standard CLIENT3 Standard CLIENT4 Standard CLIENT4 Standard CLIENT 5 (Deleted) CLIENT 5 (Deleted) CLIENT1 Standard CLIENT2 Standard CLIENT3 Standard CLIENT4 Standard CLIENT 5 (Deleted)
btw. XL2010 and XL2013 will work with Power Query after instal Power Query add-in
Amazing thanks very much Sandy!
You are welcome
Have a nice day
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks