Rows to columns

[GavinD]

Hello all..............first post from an extremely newbie Excel user.
My apologies if this particualr forum isnt the correct one for this
post, however here goes

OK, I've attached scren print of an excel spreadsheet (small extract of
a larger one). On it there are columns A -> F. In column C there are 4
or 5 rows relating to one address.

What i'm trying to do is move these rows into one single row, but move
the number at the start of the address into the column in front. The
ain is to be able to sort the entire work sheet into alphabetical order
based on the street. Hopefully what i'm trying to say should be clearer
if you look at the spreadsheet.

LOL..............to anyone whos read this far, thank you If anyone
can actually help me with this, you'll have my eternal thanks (and be
happy in the knowledge youve saved my forhead from the constant
pummelling agisnt the desk its been receiving over the last two days).

Thanks all


+-------------------------------------------------------------------+
|Filename: Doc1.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3870 |
+-------------------------------------------------------------------+

 

[Jef Gorbach]

Hello all..............first post from an extremely newbie Excel user.
My apologies if this particualr forum isnt the correct one for this
post, however here goes

OK, I've attached scren print of an excel spreadsheet (small extract of
a larger one). On it there are columns A -> F. In column C there are 4
or 5 rows relating to one address.

What i'm trying to do is move these rows into one single row, but move
the number at the start of the address into the column in front. The
ain is to be able to sort the entire work sheet into alphabetical order
based on the street. Hopefully what i'm trying to say should be clearer
if you look at the spreadsheet.

LOL..............to anyone whos read this far, thank you If anyone
can actually help me with this, you'll have my eternal thanks (and be
happy in the knowledge youve saved my forhead from the constant
pummelling agisnt the desk its been receiving over the last two days).

Thanks all


+-------------------------------------------------------------------+
|Filename: Doc1.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3870 |
+-------------------------------------------------------------------+

It sounds like the data is in a consisent layout so a macro should be able
to logic its way thru the data collasping the address block into a single
row then add temporary columns for the street# and street_name for the sort.
never run macros (even finished ones) against your only data just in case
something goes wrong.

OE/something stripped your attachment from your posting to
microsoft.public.excel so email it to <jefgorbach at aol.com> and i'll see
what help i can offer.