|
| 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
July 15th 12, 03:09 PM
|
|||
|
|||
trying to get data from rows to columns
Hello!
I was wondering if anyone could help me; I have about 200 rows of data, with about 200 values in each row, but I would like to have the information that is in each row, to be in a column instead, just wondering is there a quick way of doing this as opposed to copying and pasting each of them? All help appreciated! thank you, Kathryn 
|
| Ads |
|
#2
July 15th 12, 05:26 PM
|
|||
|
|||
|
Quote:
Should do exactly what you're after.
|
|
#3
July 16th 12, 11:47 AM
|
|||
|
|||
|
Quote:
Thank you that worked great! Kathryn
|
|
#4
July 16th 12, 02:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
trying to get data from rows to columns
On Sunday, July 15, 2012 9:09:40 AM UTC-5, Kathryn39 wrote:
> Hello! > > I was wondering if anyone could help me; I have about 200 rows of data, > with about 200 values in each row, but I would like to have the > information that is in each row, to be in a column instead, just > wondering is there a quick way of doing this as opposed to copying and > pasting each of them? > All help appreciated! > > thank you, > > Kathryn > > > > > -- > Kathryn39 This should do it Sub transposeemSAS() Dim lr As Long Dim i As Long lr = Cells(Rows.Count, 1).End(xlUp).Row For i = 1 To lr Rows(i).Copy Cells(Rows.Count, i).End(xlUp)(2).PasteSpecial _ Paste:=xlPasteAll, Operation:=xlNone, _ SkipBlanks:=False, transpose:=True 'MsgBox i Next i Rows(1).Resize(lr).Delete End Sub
|
|
#5
July 16th 12, 06:37 PM
|
|||
|
|||
|
Quote:
|
|
#6
October 9th 12, 04:18 PM
|
|||
|
|||
|
Quote:
You can try recording a micro to do your job. On the other hand you can use OFFSET formula to do your job. You can also visit http://www.techyv.com/questions/simp...ow-data-column for more information. I hope this would be of some help.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Rows to Columns - Diff Size Rows of Data | Mishelley | Excel Programming | 4 | January 28th 09 02:00 PM |
| VBA code for moving data from even rows to columns after data in oddrows | Steve G[_4_] | Excel Programming | 4 | July 5th 08 05:26 PM |
| Data from rows into columns | Dave | Excel Discussion (Misc queries) | 1 | February 11th 08 02:35 PM |
| Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | pfdino | Excel Discussion (Misc queries) | 2 | March 19th 07 09:03 PM |
| Data from Rows into columns | BCLivell | Excel Discussion (Misc queries) | 7 | May 8th 06 08:27 PM |
Linear Mode
