Jay S

Jay S

  • NA
  • 230
  • 59.2k

PIVOT - Non Aggregate

Jun 17 2013 10:26 AM
I have a simple table like this:

QRefRefNumScore
1.01720191
1.02720192
1.03720194
1.04720194
1.05720191
1.06720190
1.07720192
1.08720190

And I need to pivot it out like this:

RefNum1.011.021.031.041.051.061.071.08
7201912444102

No aggreation, pretty much a transpose...can't work it out for the life of me..

The QRef won't always be 1.01,1.02....1.08 they could be different each time

Answers (2)