I have sheet 1 as laid out below. Column A will have a list of numbers the same (then they change) with different numbers next to them. I need them to be put on sheet 2 with the numbers in column B next to them with a slash and a gap added, rather than in a list, like the result in sheet 2 and the same when the number in A changes and so on.... Thanks Before Code Excel 2010
|13||MS001||377 906 309C|
|2||MS001||46531222/ 60811067/ 60814507/ 500309838/ 9609992380/ 377 906 309C|
|3||MS002||60811534/ 16137039/ 5234313/ 33000153|
This question generated 27 answers. To proceed to the answers, click here.
This thread is current as of November 14, 2014.