Data from row to Column

amna77

Active Member
Joined
May 9, 2002
Messages
251
Hi There,
I am having trouble with row and columns.
Actually I have data in one row.

right now I have one row and 4 columns
Row1= A B C D

now I want to Take this data from this row and paste it under one column on different sheet, but on 4 rows.
A
B
C
D

and rows can grow, some times, data is going to be only in 2 rows, and some times it could be 20 rows.
So can you please tell me a way how to find out the last row. One you run the macro, it should always look all rows with data and put them in column.
Like data from row 1, should go to column 1 in next sheet.
and row 2 data should go to under column 2 in next sheet and so on.
Please help me out here. I shall be thankful to you.
Thanks
This message was edited by amna77 on 2002-05-10 14:38
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Also, you'll want an error trapper if you have more than 256 rows of data. Excel only has 256 columns, transposing 300 rows will indeed make excel crash. Something like the following:

Code:
Sub test()
Dim i As Long
i = Sheet1.[a65536].End(xlUp).Row 'test column A
If i > 256 Then
MsgBox ("You have more rows than available columns, XL will crash." _
    & Chr(13) & Chr(13) & "Task Aborted.")
End
End If
Sheet1.Range("a1:d" & i).Copy '4 columns wide a:d (change if necessary)
Sheet2.[a1].PasteSpecial Paste:=xlAll, Transpose:=True
Sheet2.[a1].Select 'only because transposing selects without our permission
Application.CutCopyMode = False
End Sub

Change sheet1 & sheet2 to sheets("sheet name"), etc...

Hope this helps.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
wave.gif

This message was edited by NateO on 2002-05-10 15:01
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,072
Members
448,546
Latest member
KH Consulting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top