how do I automate transposing of multiple rows with multiple columns

[byrddog75]

see attached spreadsheet

I need to transpose columns to rows, for each row.
Instead of transposing each one individually, how can I automate this, so that all rows are transposed into column a or a new sheet?
eg
tranpose row 1 into column
transpose row 2 into column
etc until done

Thanks

[FDibbins]

H and welcome to the forum

Try this, copied down and across...

=INDEX($A$1:$H$13,COLUMN(A1),ROW(A1))
adjust ranges as needed

[byrddog75]

Thanks. Getting closer.

See new attachment on results. How can I get all the results to display in one column? That is my goal. I am okay with spaces between some rows.
Do you have a phone number or IM? I can share computer screens so we can wrap this up easier.

Example of column:
row 1 col 1
row 1 col 2
row 1 col 3
etc until row 1 is done

row 2 col 1
row 2 col 2
row 2 col 3
etc until row 2 is done

continues down this column until above sequence is completed for all rows

[kvsrinivasamurthy]

Alternative method.

Copy the whole data.
Select the first cell where you want to paste.
Rightclick
Select pasteSpecial
Check Values and Transpose
Click OK.
Now done.

[kvsrinivasamurthy]

Alternative method.

Copy the whole data.
Select the first cell where you want to paste.
Rightclick
Select pasteSpecial
Check Values and Transpose
Click OK.
Now done.

[byrddog75]

@kvs...
That is giving the same output as before.
The originating cell range is A1 - h13

I want all of the output to move under only one column. Not different columns. What output looks like in first 3 columns:

Choose Model--Choose Model||0|0.00|0| Choose Size--Choose Size||0|0.00|0| Choose Size--Choose Size||0|0.00|0|
14" Medium Crash|MB10-14MC-B|149.99|0.00|0| Soundcaster Fusion 16" Trash Crash Cymbals|SF16TR|219.99|0.00|0| Byzance Brilliant 16" Medium Crash|B16MC-B|239.99|0.00|0|
15" Medium Crash|MB10-15MC-B|179.99|0.00|0| Soundcaster Fusion 18" Trash Crash Cymbals|SF18TR|259.99|0.00|0 Byzance Brilliant 18" Medium Crash|B18MC-B|279.99|0.00|0|
16" Medium Crash|MB10-16MC-B|199.99|0.00|0| Byzance Brilliant 20" Medium Crash|B20MC-B|329.99|0.00|0
17" Medium Crash|MB10-17MC-B|219.99|0.00|0|
18" Medium Crash|MB10-18MC-B|239.99|0.00|0|
19" Medium Crash|MB10-19MC-B|259.99|0.00|0|

Instead, I want it to output like this:

Choose Model--Choose Model||0|0.00|0|
14" Medium Crash|MB10-14MC-B|149.99|0.00|0|
15" Medium Crash|MB10-15MC-B|179.99|0.00|0|
16" Medium Crash|MB10-16MC-B|199.99|0.00|0|
17" Medium Crash|MB10-17MC-B|219.99|0.00|0|
18" Medium Crash|MB10-18MC-B|239.99|0.00|0|
19" Medium Crash|MB10-19MC-B|259.99|0.00|0|

Choose Size--Choose Size||0|0.00|0|
Soundcaster Fusion 16" Trash Crash Cymbals|SF16TR|219.99|0.00|0|
Soundcaster Fusion 18" Trash Crash Cymbals|SF18TR|259.99|0.00|0

Choose Size--Choose Size||0|0.00|0|
Byzance Brilliant 16" Medium Crash|B16MC-B|239.99|0.00|0|
Byzance Brilliant 18" Medium Crash|B18MC-B|279.99|0.00|0|
Byzance Brilliant 20" Medium Crash|B20MC-B|329.99|0.00|0


etc

[kvsrinivasamurthy]

Pl see the attached file with macro.It copies from Activesheet to Sheet2.Suitably change to your required sheet.

[m1zz13]

byrddog75 ,

kvsrinivasamurthy's method is the simplest. Simply do as follows:
1. Copy the whole data.
2. Select the first cell where you want to paste.
3. Right click
4. Select paste Special
5. Check Values and Transpose
6. Click OK.
and you're done. Tried it on your spreadsheet worked fine.