I am not good in VBA but solution can be as below
first follow the below link
http://www.excelforum.com/tips-and-t...geravatar.html
copy the code provided
then open your sheet hit Alt+F11 click insert at the menu bar at the top and click module and paste code
Then create a new sheet copy paste all column headers and copy all job number and click remove duplicates
in C2 copy paste below then hold control and shift and then hit enter to make it array formula
drag down and drag to right
Change red part to your desired flavour may be "-" or "," or something
I have used char(10) to give it a line break character, after applying formula copy paste as values only and then with all selected click wrap text.
Hope that helps
Bookmarks