Match and combine multiple rows into one
 

Hi all,

I have the data set below in three separate columns in one worksheet

A3 B3 C3
10 71 120171
10 71 43311
10 71 43312
10 72 101321
10 72 10372
1 421 42101
1 421 42102

I want the data to just match and return the first two rows and
combine it into one cell in another worksheet so it would look like
this (with the dash):

A3
10-71
10-72
1-421


Thanks!

Cheers,
Chris

Match and combine multiple rows into one
 

Add headers to row 1 (if you don't have them)
create a new column (column D???)
In D2:
=a2&"-"&b2
Drag down your list as far as you need.

Then use the technique at Debra Dalgleish's site to extract the unique entries
for that column:

http://contextures.com/xladvfilter01.html#FilterUR

If you're going to sort that data, you may want to use a formula like:

=text(a2,"000")&"-"&text(b2,"000")

so that they sort nicely.

"C." wrote:

Hi all,

I have the data set below in three separate columns in one worksheet

A3 B3 C3
10 71 120171
10 71 43311
10 71 43312
10 72 101321
10 72 10372
1 421 42101
1 421 42102

I want the data to just match and return the first two rows and
combine it into one cell in another worksheet so it would look like
this (with the dash):

A3
10-71
10-72
1-421

Thanks!

Cheers,
Chris

--

Dave Peterson