asked on

Concatenating values that match the same primary value

Hi,

I have a small concatenating type issue.

I have a list of SiteID's that use different frequencies at the site to transmit. Some sites have one frequency, others have multiple. I need to get an extract of data from:

SITE1 FREQ1
SITE1 FREQ2
SITE2 FREQ1
SITE3 FREQ4

To be similar to:
SITE1 FREQ1, FREQ2
SITE2 FREQ1
SITE3 FREQ4

I have attached the sheet with data in it to show you the format, and the required output

Any help or direction would be great.

Thanks
Site-FrequencyData.xlsx

ASKER CERTIFIED SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Snappa2000

ASKER

Dave,

I think you attached the wrong workbook :)

dlmille

Sorry, dude.

Here it is:

Site-FrequencyData-r1.xlsm

dlmille

Sorry - I was playing around with the file when I posted, with a formula (after you told me I didn't upload the right file). This one is cleaned up.

Sorry for repetative post.

Dave
Site-FrequencyData-r1.xlsm

Snappa2000

ASKER

Dave,

Awesome.. quick and precise!

Thanks will be putting this in the sample box!

Cheers

dlmille

PS - you can do this with formulas, but its pretty complex, having to build a match for every possible occurance you might need - so if you know max is 2 matches, its doable - more on this:

=VLOOKUP(K3,$A$3:$B$503,2,0) &IFERROR(", " & VLOOKUP(K3,INDIRECT(ADDRESS(MATCH(K3,$A$1:$A$503,0)+1,2)&":$A$503"),2,0),"")

it gets really unwieldy if you want 3 or more matches to be possible...

Dave