Quinnshouse
New Member
- Joined
- Nov 18, 2005
- Messages
- 5
OK, I need a little help.
I have 1 Column of names, address, phone#, Fax, Email, Etc.: A1,A2,A3,A4, Etc
NOW, NOT ALL ARE THE EXACT SAME AMOUNT OF INFO. some consist of name address phone. Then a blank row then next group might be name address phone email and more.
OK, One good thing is they are seperated by a blank row.
SO I need to get all info from 1st row to blank row in columns b1,c1,d1,etc.
Thanks to USER: Yogi Anand, I know how to get info from one column into rows. BUT I need something that will take all info up to next blank row, then start new row of info....
ANYBODY NOT CONFUSED?
Yogi Anand wrote:
In cell C1, put the following formula
=(("A"&(ROW()-1)*5+1&":A"&(ROW()*5-1)))
and copy this down from c2:c50 to take care of all of your 50 records.
Then in cell D1 write the following formula:
=Transpose(indirect(C1)) -- this is an array formula, clcick on cell D1, highlite cells D1:G1 and array enter the formula in cell D1
this will transpose the entries in A1:A4 to D1:G1
I have 1 Column of names, address, phone#, Fax, Email, Etc.: A1,A2,A3,A4, Etc
NOW, NOT ALL ARE THE EXACT SAME AMOUNT OF INFO. some consist of name address phone. Then a blank row then next group might be name address phone email and more.
OK, One good thing is they are seperated by a blank row.
SO I need to get all info from 1st row to blank row in columns b1,c1,d1,etc.
Thanks to USER: Yogi Anand, I know how to get info from one column into rows. BUT I need something that will take all info up to next blank row, then start new row of info....
ANYBODY NOT CONFUSED?
Yogi Anand wrote:
In cell C1, put the following formula
=(("A"&(ROW()-1)*5+1&":A"&(ROW()*5-1)))
and copy this down from c2:c50 to take care of all of your 50 records.
Then in cell D1 write the following formula:
=Transpose(indirect(C1)) -- this is an array formula, clcick on cell D1, highlite cells D1:G1 and array enter the formula in cell D1
this will transpose the entries in A1:A4 to D1:G1