chrisscotty
Board Regular
- Joined
- Jul 9, 2002
- Messages
- 87
Hi,
I have a list that I want to transpose. I have several hundred entries that are all in the A column that I want to transpose to rows so I can import in to a contact manager (csv file tab delimited). Then again, if there is any way of transferring the data without transposing to rows t then that would be even better =-0
The structure is as follows:
Name
Company:
E-mail:
Work Phone:
Fax:
Chapter:
Title:
So the data is in A1 to A8 (A8is blank), and I want to transpose to either the same worksheet so B2 to I7 or go to another worksheet (does not really matter to me).
Also, Does anyone know of a program that interfaces with internet explorer and excel that would allow me to get data from a database in explorer and then paste the data in excel as a macro ?.
I have a database that I want to enter but it only lets me get one entry at a time.
Thanks For Your help !.
I have a list that I want to transpose. I have several hundred entries that are all in the A column that I want to transpose to rows so I can import in to a contact manager (csv file tab delimited). Then again, if there is any way of transferring the data without transposing to rows t then that would be even better =-0
The structure is as follows:
Name
Company:
E-mail:
Work Phone:
Fax:
Chapter:
Title:
So the data is in A1 to A8 (A8is blank), and I want to transpose to either the same worksheet so B2 to I7 or go to another worksheet (does not really matter to me).
Also, Does anyone know of a program that interfaces with internet explorer and excel that would allow me to get data from a database in explorer and then paste the data in excel as a macro ?.
I have a database that I want to enter but it only lets me get one entry at a time.
Thanks For Your help !.