How to transpose columns to row using vba codes

[ricardo2012]

i need help how to automate my files. i dont know exactly how to say it so i attached my sample files for you to figure out, i doing this manually and its really painful. Big Thanks.,

[patel45]

From forum rules

Want to get your question answered quickly?

Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

[ricardo2012]

Thanks a lot for your advice

[ricardo2012]

I would like to be able to transpose data that is in Columns into Rows, i attached my files one is the input file and other would be the output file. Is there a way to make this dynamic

[Cutter]

Hello ricardo2012, and welcome to the forum.

You haven't attached a file. Here's how:

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[ricardo2012]

I attached the sample file

[patel45]

We are fortunate to have several Excel gurus, but few mind-readers.
If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant.

[ricardo2012]

patel tell me what is the best question,

[nilem]

Hi Ricardo2012, try it

Please Login or Register  to view this content.

[ricardo2012]

Nilem, this is excellent job, it works very well, you made my day complete, your the Best

[Cutter]

@ ricardo2012

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.