Dear all,
I want to transfer/transpose large number of columns into rows (while maintaining the code column for each row). I have attached an excel as an example. Unfortunately I don't have the power query from excel since I run Excel on Mac. I run Excel version 16.38. Any way how I can do this? I have limited Excel knowledge but I know how to run a VBA code. Thanks in advance for the help!
With the code below.
See the attached file.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Dear Oeldere,
Many, many thanks for this quick solution! It works like a charm on my entire excel. Great work!
Glad I could help.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks