Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks fail when constructed using Autofil | Excel Programming | |||
Rearranging Alphabetical List | Excel Discussion (Misc queries) | |||
Reading in poorly formatted text file | Excel Discussion (Misc queries) | |||
Rearranging columns | Excel Programming | |||
vlookup with table_array constructed from mid formula | Excel Worksheet Functions |