Macro or even a formula will do..Before that a quick query?

If it is 3 bits it should be 1200 rows and not 1201. Do you have blank
spaces inbetween?



If this post helps click Yes
---------------
Jacob Skaria


"Lister" wrote:

I have scanned some customer lists into excel via a lengthy process and it
has given me one column of data. the data is of 3 rows Name,address,phone
number. I dont have a header but i can add if i need. I would like to
transpose the data (the second and third lines) to column b and c
respectivley, But for the enitre list which is 1201 rows long...i have tried
a few macros i have found and tried to modify them to just 3 rows but i dont
understand Visual basic very well. I appreciate and give many thanks for all
the help you my give me in advance. Glenn