I solved my problem.

It appears UnPivot didn't like the fact that I had a single column without a matching second column in one instance. I put a dummie column in...

I am moving 15 columns into 2 columns. My transformation editor looks like this.

Input Column Destination Column Pivot key value

WC_NPPCNPPCWC

MTN_NPPCNPPCMTN

SW_NPPCNPPCSW

SE_NPPCNPPCSE

MW_NPPCNPPCMW

EC_NPPCNPPCEC

GL_NPPCNPPCGL

WC_DirectDIRECTWC

MTN_DirectDIRECTMTN

SW_DirectDIRECTSW

SE_DirectDIRECTSE

MW_DirectDIRECTMW

EC_DirectDIRECTEC

GL_DirectDIRECTGL

HI_DirectDIRECTHI

When I put it into your format (as I understand it)...

I could definitely use a few pointers about unpivoting multiple columns. I am using SQL 2005 with the compatibility level of 80.

I keep getting the message: "PivotKeyValue is not...

Marc

Add your value field to the data area a second time. Excel will designate the results as Sum of Value2. Right click on the row/column header for this data. Select...