Converting Vertical Columns in to Horizontal Rows - (Better solution to Transpose)
Hello Friends,
I am in trouble of converting Vertical Columns to Horizontal Rows. I used Transpose function but I have too many data to perform the Transpose function.
Is there any other formula to do it in simple manner, which can work on large data smoothly??
My data file is attached here with for your reference.
Thanks in Advance.
This can be easily done with a small macro. Would you be interested?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes, I am interested. Please help me.
Try this code
Copy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
Hello, I think I was not able to communicate my problem properly.
In my attached file there are two sheets, first is "Current Data" which I downloaded from ERP system in to Excel, I need a formula or Macro so that I get the result as shown in my second sheet "want result by Formula"
Hope it is clear now.
Please help.
Best Regards,
Ok, so the output is fine right? It just needs to show up in a different sheet?
Yes, you are right. I want the result in a different sheet with out disturbing original data.
I must thank you for your help.
Try this
Please Login or Register to view this content.
I am very very thankful to you, I tried to thank you earlier also but having some internet issues. You are truly a genius.
Many Many thanks again.
Since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks