If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
FUNCTION
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?!? |
#2
|
|||
|
|||
FUNCTION
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 |
#3
|
|||
|
|||
FUNCTION
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?!? |
#4
|
|||
|
|||
FUNCTION
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... |
Thread Tools | |
Display Modes | |
|
|