how to collect some blocks into one block

Posted by EYAL on December 26, 2001 7:51 AM

i need to take all the first line blocks (from a1 to z1) and to put them all the info together in one block B2 (for example) with commas seperating between them .

Posted by Scott on December 26, 2001 8:17 AM

How about this formula in B2:
=A1&","&B1&","&C1&","&D1&","&E1&","&F1&","&G1&","&H1&","&I1&","&J1&","&K1&","&L1&","&M1&","&N1&","&O1&","&P1&","&Q1&","&R1&","&S1&","&T1&","&U1&","&V1&","&W1&","&X1&","&Y1&","&Z1

It's long, but it works.