rearranging information!?!

Danielle,

Copy your data from column A up to 255 rows. Right mouse click on B1 and select Paste Special and select Values + Transpose. Excel only has 256 columns so you could only get 51 sets of data if you include a space between each. You would have to start on a new row for each 51 sets you have. Once you have moved all of your data you can then delete column A.


HTH

Steve

Hi Steve,

Thanks for your advice. When I did what you suggested it took the information and spread it all out over row 1 column a,b,c...x,y,z and nothing was in any other row.

What I need it to do is this...

Company name Company address Company city Company phone
Company name Company address Company city Company phone
Company name Company address Company city Company phone
Company name Company address Company city Company phone

Thanks!

Danielle

Hi Danielle,

Sorry for the misinterpretation on your OP. This may not be the easiest way but it worked for me. Assuming your data is in column A with no header you can start by selecting A1:A4, Copy and Paste Special Values + Transpose into B1. then using column F as a helper column in F2 type in the number 1. In
F3 type in F2+5. Copy this down until the returned value matches the row number of the second to last Company Name listed in A.

In B2 enter, =OFFSET(INDIRECT("A"&$F2),COLUMN(E1),0)

You can then drag this across to E2 and down to your last value in F. Once you have all of your data you can copy and Paste Special Values over B1:E?and delete column A and the helper column.

HTH

Steve