A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

FUNCTION



 
 
Thread Tools Display Modes
  #1  
Old May 16th, 2010, 04:47 PM posted to microsoft.public.excel.worksheet.functions
WILT
external usenet poster
 
Posts: 2
Default 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  
Old May 16th, 2010, 05:00 PM posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_4_]
external usenet poster
 
Posts: 74
Default 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  
Old May 16th, 2010, 05:02 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default 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  
Old May 16th, 2010, 08:01 PM posted to microsoft.public.excel.worksheet.functions
Stan Brown
external usenet poster
 
Posts: 536
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.