combining duplicate row values?

  • Thread starter Thread starter Dave Jones
  • Start date Start date
D

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
 
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.
 
TY

I always thought this was not possible. Shows the value of actually reading
reference material. Especially those you send people!
 
AltaEgo said:
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.
Click to expand...

thanks! I'll check out the link
Dave
DDP
 
Back
Top