I have an issue that I'm having a hard time solving because it's kind of hard to describe:
I have some data arranged:
a11 a12 a13
a21 a22 a23
a31 a32 a33
a41 a42 a43
and I need to arrange it into a column vector of:
a11
a21
a31
a41
a12
a22
a32
a42
a13
a23
a43
for several thousand numbers. Is there anyway I can speed up this process? When I try to find help online I keep getting directed to the transpose command.
Many thanks.
You don't really need transpose. Just select the data in column B, cut it and paste it at the bottom of the data in column A. Repeat the process for column C.
Sort column A, if you wish.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or if there are too many columns try this:
Please Login or Register to view this content.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I get an error message that the Sheets("Sheet2").Range("A1").Offset(k - 1, 0) = Sheets("Sheet1").Range("A1").Offset(j - 1, i - 1) line has subscripts out of bounds. Any ideas on what might be causing this or how I might solve this problem?
If you run the code from the active sheet, the output is in new sheet.
Hello raej,
Welcome to the Forum!
If your columns are already formatted then it is much faster to transfer the cells' values into an array, manipulate the array, and save the array back to the worksheet.
This macro expects the data to be in a table format. It satrts a cell "A1" of the active sheet. You can change "A1" to the starting cell of your table.
The transposed data will be in the first column. All other columns will remain untouched.
Please Login or Register to view this content.
Last edited by Leith Ross; 07-09-2013 at 01:59 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Awesome! This saved me TONS of time. I'm very appreciative for your help!
Hello raej,
Whom are you thanking? There were four people who responded to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks