T
Tony Pass
I often get lists of contacts that are generated in one long column. They are
often may be 4 or 5 rows per record. In order to be able to use the data I
need to transpose the rows in each record (one column) to new columns. It may
include Company Name in Row A1 and contact name in Row B1 and perhaps Phone
or Web Site in C1 etc. The records are always the same amount of rows. I have
tried copy, transpose, and text to rows and anything else I can think of. Can
anyone make a suggestion ?? Thanks in advance Tony Pass
often may be 4 or 5 rows per record. In order to be able to use the data I
need to transpose the rows in each record (one column) to new columns. It may
include Company Name in Row A1 and contact name in Row B1 and perhaps Phone
or Web Site in C1 etc. The records are always the same amount of rows. I have
tried copy, transpose, and text to rows and anything else I can think of. Can
anyone make a suggestion ?? Thanks in advance Tony Pass