Had a question about maybe a function.... this is what i got

A B C
1 TIM MAY 16
2 WAYNE JUNE 12
3 ROB MARCH 24


and i was looking to make it like this

A B C
1 TIM WAYNE ROB
2 MAY JUNE MARCH
3 16 12 24

any suggestions?1?!?

On Sun, 16 May 2010 08:47:01 -0700, wilt
wrote:

Had a question about maybe a function.... this is what i got

A B C
1 TIM MAY 16
2 WAYNE JUNE 12
3 ROB MARCH 24


and i was looking to make it like this

A B C
1 TIM WAYNE ROB
2 MAY JUNE MARCH
3 16 12 24

any suggestions?1?!?

Select cells A1:C3
Right click anywhere inside the selection av choose "Copy".

Right click on an empty space and choose "Paste Special".
In the dialog that appears tich the "Transpose" checkbox and then
click on OK.

Your transposed data table can now be Cut and Paste to the original
location, i.e. cells A1:C3.

Hope this helps / Lars-Åke

Try this

Dim NumRows As Long
Dim NumCols As Long

With ActiveSheet

NumRows = .Cells(.Rows.Count, "A").End(xlUp).Row
NumCols = .Cells(1, .Columns.Count).End(xlToLeft).Column
.Range("A1").Resize(NumRows, NumCols).Copy
.Range("A1").Offset(, NumCols).Resize(NumRows, NumCols).PasteSpecial
Transpose:=True
.Range("A1").Resize(, NumCols).EntireColumn.Delete
End With

--

HTH

Bob

"wilt" wrote in message
...
Had a question about maybe a function.... this is what i got

A B C
1 TIM MAY 16
2 WAYNE JUNE 12
3 ROB MARCH 24


and i was looking to make it like this

A B C
1 TIM WAYNE ROB
2 MAY JUNE MARCH
3 16 12 24

any suggestions?1?!?

Sun, 16 May 2010 08:47:01 -0700 from wilt
:

Had a question about maybe a function.... this is what i got

A B C
1 TIM MAY 16
2 WAYNE JUNE 12
3 ROB MARCH 24


and i was looking to make it like this

A B C
1 TIM WAYNE ROB
2 MAY JUNE MARCH
3 16 12 24

any suggestions?1?!?

Look up "transpose" in Excel help.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...