View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lister Lister is offline
external usenet poster
 
Posts: 4
Default Rearranging a Very poorly constructed list

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