Hi

I need to convert column data into row data

From this

Name Address
Fred 30 Jones St
London
Sue Tower 42
London
EC2

To this

Name Address1 Address2 Address3
Fred 30 Jones St London
Sue Tower 42 London EC2


I have a macro that can convert but the problem is that
each person address is has a variable amount of fields.
Any way round this

Thanks for any help

David