LinkBack URL
About LinkBacks
ooops correction, the output should be (2 columns, 4 rows):
entry1 entry5
entry2 entry6
entry3 entry7
entry4 entry8
ooops correction, the output should be (2 columns, 4 rows):
entry1 entry5
entry2 entry6
entry3 entry7
entry4 entry8
may be ...
P.S. replace 5 by 4 for your last example ...
=OFFSET($A$1,MOD(ROW()-1,5)+(COLUMN()-1)*5,0)
Last edited by Carim; 03-05-2007 at 06:05 AM.
AHHH YES!
That worked, thanks a lot
Sorry I didn't attach the xls file, the upload failed...
- Marco
Glad your problem is fixed ...
Thanks for the feedback
I have a similar problem
I have a list generated by a proprietary software. It has taken the entire address list for people and put them one after the other in a single column.
How can I move these rows out to separate columns using a macro or other step that will keep me from going through 11,000 rows to correct this data?
Marion
PS I am told that this is the only way this software can generate this list, so I will be dealing with this over and over again.
you have to tell us how many rows there are for each record and does it vary. maybe even post a zipped version of the top few lines of the spreadsheet
Regards
Dav
Hi Marion,
Assuming all your data is in column A, copy formula to cell B1 and
adapt it to your needs :
since the number 5 represents the number of rows required,=OFFSET($A$1,MOD(ROW()-1,5)+(COLUMN()-1)*5,0)
just replace the number 5 by whatever number you wish ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks