How to combine all columns into one column in Excel

• nil-269516

  Valued Member

  Points: 57

  More actions

  October 16, 2005 at 3:16 am

  #169182

  Greetings to all,

  I have this problem combining all the columns in one excel file to only one column.

  For e.g.

  Column A= 10 rows

  Column B= 10 rows

  Column C= 12 rows

  How can I do this in perhaps Excel or SQL Server 2003?

  I would like to have only 1 column which consists of 32 rows refering to the example above.

  I am coping with around 300 columns each day, so I would like to have a better solution.

  Thanks.

  cheers,

  -NoeL-

• Jo Pattyn

  SSC-Dedicated

  Points: 32578

  More actions

  October 16, 2005 at 4:36 am

  #597515

  make an union?

  select columnA as MyColumn

  union all

  select columnB as MyColumn

  union all

  select columnC as MyColumn