Transposing Macro

[catunivdl919]

Hi all,
I have a spreadsheets that has a product ID with 8 (Columns) prices on a single row.
I need to transpose this spreadsheet into a spreadsheet that has 8 Rows for each product ID.

There are around 4500 rows that need to be converted. I can do manually but you can imagine how long that would take. Please help.

Old Sheet
Capture Price 1.PNG

New Sheet
Capture 2.PNG

Any help will be greatly appreciated.

Thanks in advance.

[stnkynts]

I may be my computer but I am not able to see your pictures. A sample workbook with a before and after example would be more useful.

[TMS]

Please post a sample workbook with some typical data.

Regards, TMS

[catunivdl919]

Pricing sheet.xlsx

here is the file. thanks again.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Slightly neater version:

Please Login or Register  to view this content.

Could probably be done quicker with arrays but I'll leave that to someone else.

Regards, TMS

[catunivdl919]

TMS,

Thanks it worked great. Do you have any resources for me to learn coding?

Thanks.

[stnkynts]

Do you have any resources for me to learn coding?

There is a sticky on the front page with a lot of information.

http://www.excelforum.com/excel-prog...materials.html

[TMS]

You're welcome.

stnkynts has provided a link which has lots of information. However, I tend to find that it is quite difficult to learn something "for the sake of it".

ideally, you need to set yourself a challenge, perhaps to address a business problem or improvement, and then research how best to address it, either with formulae or VBA coding. If you want to learn VBA, one of the best ways is to record a macro whilst you undertake a task. Then look at the macro to see how it works, and how it can be improved.

One of the reasons I answer questions on the forum is NOT because I know everything ... I wish ... but to address challenges and learn from them, and from the solutions that others offer.





If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[TMS]

Please mark the thread as solved. Thank you.