J Livingston SQL (10/9/2013)
LutzM (10/9/2013)
Why did you open another thread?What about the answers already provided here?
that post was to split into columns.....now it seems into rows.....
Yep, you're right.
I must have missed the sample data and expected result provided by the OP in both threads. Therefore missing the obvious. 😉
I'd say both requirements most probably can be transformed into each other using pivot (or CrossTab, as I'd prefer) or unpivot of the "other" result set.