Convert Column to row with variable data

Giganews Newsgroups
Subject: Convert Column to row with variable data
Posted by:  David Randall (dranda…@lw.com)
Date: Thu, 9 Oct 2003

Hi

I'm using Excel 2k and I have a spreadsheet that looks
like this

Name    Address
Fred    21 Blah St
        London
Sue    Tower 50
        London
        EC2

and need it to look like this

Name  Address 1    Address2  Address3
Fred  21 Blah St    London
Sue    Tower 50      London    EC2

I have a macro that can convert from column to row but
only for a set number of columns.  Is there any way to
account for the variable amount of data for each address ?

Any help much appreciated

Thanks
David

Replies