combining duplicate row values?

[Dave Jones]

Excel 2007
XP Pro SP3

I have several rows of data as:

1 gl 24 36 cw1 north 1st
1 g2 24 36 cw2 north 1st
1 gl 24 36 cw1 north 1st
1 g2 24 36 cw2 north 1st
1 gl 24 36 cw1 north 1st

that I would like to combine (preferably into a separate worksheet) as:

3 gl 24 36 cw1 north 1st
2 g2 24 36 cw2 north 1st

based on rows 1, 3, and 5 and rows 2 and 4 having duplicate data. Is
there a way to do this?
Dave
DDP

 

[AltaEgo]

1) Use the options in advanced filter to copy unique records to a location
in the same worksheet. (Advanced filter does not copy to alternate sheet).
2) Move the records to the required sheet.

For information on advanced filters:

http://www.contextures.com/xladvfilter01.html

You could automate the process by recording a macro. If you do, specifying
whole columns of data in the filter criteria and the move process will save
work finding the range size.

 

[Peo Sjoblom]

You can actually use advanced filter and copy the result to another sheet,

also from Debra's site


http://www.contextures.com/xladvfilter01.html#ExtractWs



--


Regards,


Peo Sjoblom

 

[AltaEgo]

TY

I always thought this was not possible. Shows the value of actually reading
reference material. Especially those you send people!

 

[Dave Jones]

1) Use the options in advanced filter to copy unique records to a
location in the same worksheet. (Advanced filter does not copy to
alternate sheet).
2) Move the records to the required sheet.

For information on advanced filters:

http://www.contextures.com/xladvfilter01.html

You could automate the process by recording a macro. If you do,
specifying whole columns of data in the filter criteria and the move
process will save work finding the range size.

thanks! I'll check out the link
Dave
DDP

 

[Dave Jones]

You can actually use advanced filter and copy the result to another sheet,

also from Debra's site


http://www.contextures.com/xladvfilter01.html#ExtractWs

even better Thanks for the assistance!
Dave
DDP