Most valuable professional
  • Hot Topics

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 8 9 10 11 12 13 14 15 16 17 Sheet1 After Code Excel 2010 2 3 Sheet2 Last edited by Dazzawm; Yesterday at 06:32 AM.

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel