Sarah,

Select your data and copy.
Select the blank row above your data (This shouldn't have been copied)
Edit|Paste special
Check (or as we say in England tick) transpose
Click OK

Mike

"Sarah" wrote:

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.

--
Sarah