S
Sarah
Hi and I really hope someone out there can help. I have an address list in
one column in Excel. It looks like this
Blank Row
Company Name
Address 1
Address 2
Address 3
Sometimes Address 4
County (I live in England) so equivalent to State
Post Code so equivalent to Zip Code
Tel Number
Blank Row
etc
I want to tranpose it so that I have Company Name in Column 1, Address 1 in
Column 2, Address 2 in Column 3 and so on. I have looked in the forums and
there are solutions for this where there is a regular number of lines for the
address.
My problem is that some of the entries have 3 rows for the full address and
some have 4.
There is a blank row between every entry.
Every tel number is preceded by the characters Tel:
The line before every tel number is always the Post Code
The line before the Post Code is always the County
I would obviously like the columns to line up so that I can filter by County
or Post Code.
Is anyone able to help with this please?
All suggestions gratefully received.
one column in Excel. It looks like this
Blank Row
Company Name
Address 1
Address 2
Address 3
Sometimes Address 4
County (I live in England) so equivalent to State
Post Code so equivalent to Zip Code
Tel Number
Blank Row
etc
I want to tranpose it so that I have Company Name in Column 1, Address 1 in
Column 2, Address 2 in Column 3 and so on. I have looked in the forums and
there are solutions for this where there is a regular number of lines for the
address.
My problem is that some of the entries have 3 rows for the full address and
some have 4.
There is a blank row between every entry.
Every tel number is preceded by the characters Tel:
The line before every tel number is always the Post Code
The line before the Post Code is always the County
I would obviously like the columns to line up so that I can filter by County
or Post Code.
Is anyone able to help with this please?
All suggestions gratefully received.