Split Out Values to New Columns

• David-155102

  SSCarpal Tunnel

  Points: 4361

  More actions

  May 30, 2007 at 8:37 am

  #173827

  I have a file which contains the following sample data:

  Col A	Col B	Col C	Col D
  6	Jul	2500	1
  6	Aug	2800	2
  6	Aug	3000	3
  6	Sep	2505	1
  6	Oct	5000	2
  6	Oct	6000	3
  6	Jul	2301	5

  I would like to format the data so that Col B is split out to create new columns as follows:

  Year	Line	Jul	Aug	Sep	Oct
  6	2500	1
  6	2800		2
  6	3000		3
  6	2505			1
  6	5000				2
  6	6000				3
  6	2301	5

  Does anyone know if this is possible using SSIS?

• ArkWare

  Mr or Mrs. 500

  Points: 525

  More actions

  May 31, 2007 at 7:05 am

  #709977

  David,

   

  Look at the Pivot data transformation.

  Ron