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:
To be similar to:
SITE1 FREQ1, FREQ2
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.