Excel: Code To Move From Vertical To Horizontal?


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

A B
8 MS001 46531222
9 MS001 60811067
10 MS001 60814507
11 MS001 500309838
12 MS001 9609992380
13 MS001 377 906 309C
14 MS002 60811534
15 MS002 16137039
16 MS002 5234313
17 MS002 33000153
[CENTER]Sheet1[/CENTER] After Code Excel 2010
A B
2 MS001 46531222/ 60811067/ 60814507/ 500309838/ 9609992380/ 377 906 309C
3 MS002 60811534/ 16137039/ 5234313/ 33000153
[CENTER]Sheet2[/CENTER]


This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of November 14, 2014.


For more resources for Microsoft Excel