Swapping rows of data to columns 2

[shawnmandel]

Is there any easyway to swap a number of rows of data to the same number of columns?

For example, I have 50 items of text in Column C starting on Row 44 and I would like to pivot these items so they appear on Row 44 across columns starting in Column C.

Did I just answer my own question by using pivot tables, or is there another way?

Thanks,
Shawn

 

[shawnmandel]

Oh, and I need my resulting single row of data across the columns to appear in the exact order as they appeared in the rows down a single column.

Thanks,
Shawn

 

[Zathras]

Copy / Paste Special (Tick Transpose)

 

[PHV]

You may try something like this:
Range("C45:C93&quot.Copy
Range("D44&quot.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Range("C45:C93&quot.ClearContents

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[PHV]

Zathras, you beat me while I tested my code

 

[shawnmandel]

Thanks so much. Saves me so much time.

Shawn

 

[KenWright]

For a one time operation you have your answers, but if you needed a linked table of transposed values, then take a look at the TRANSPOSE() function.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------