98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sorting Data in Excel
Sorting Data in Excel
Resolved · Medium Priority · Version 2003
Fri 14 May 2010, 16:32Delegate Lee said...
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?
Wed 19 May 2010, 13:41Trainer Andrew said...
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
Fri 28 May 2010, 10:53Delegate Lee said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create a unique items table from a duplicating table1. Ensure that your list has column headings |
