Lee has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course
Sorting Data in Excel
Hi Guys,
Can you please help with the following question?
I have two columns of data in Excel, the first is a dealer number and the second is the postcodes they are responsible for. Each dealer has multiple entries one for each post code, so the dealer number is listed many times, once for each valid post code.
What I need to achieve is all of the post codes for each dealer to be in one cell split by a comma. For example,
From
Dealer Post Codes
133 ZE1
133 ZE2
133 ZE3
To
Dealer Post Codes
133 ZE1, ZE2, ZE3
I though about a pivot table but have not been able to make it work. Any suggestions?
RE: Sorting Data in Excel
Hi Lee
Thank you for your question. I will check with one of my colleagues to see if it's possible to do this using functions rather than using VBA programming
Kind regards,
Andrew
RE: Sorting Data in Excel
I have managed to move this problem on a bit, I now have my postcodes in seperate cells by dealer number. My next problem is how to combine up to 55 cells into one with the postcodes seperated by a comma.
I have looked at cocantenate but cannot work out how to automatically add the comma without manually adding one cell at a time to the formula.
Have,
ZE1 ZE2 ZE3 in three cells.
Need
ZE1, ZE2, ZE3 in one cell.
