Scripts for automatically transposing alot of columns into rows?

[naturegirl]

Is it possible to write a script that would automatically transpose alot of columns into rows?

188 records, each with average of 5 columns to transpose in preparation for import into relational database...

or shall i just get clicking, copying, pasting?

Thanks!!

[hemesh]

Hello Welcome to the forum ! can you please upload a workbook (with sensitive data Removed)

[naturegirl]

script to transpose.xlsx

Here is my example file...many thanks!!

[naturegirl]

I found this...but it's different

http://www.excelforum.com/excel-form...to-column.html

[hemesh]

select the data you want to change select the cell where you want to paste it go to paste special (right click) and select transpose at the bottom of paste special

if answer helps you click "*" (add rep) and mark thread as solved go to thread tools and select mark solve

[naturegirl]

That's what I am doing, as per my example file, so no, that hasn't helped...there are 180 rows so alot of click-copy-pasting

there must be an easier way as per the example I made reference to.

Can anyone help? Thanks!

[AB33]

This is not a formula but a macro code. When you run it, the result will be in new sheet.

[naturegirl]

THANKS very much...!!!!!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, 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.