Hi,
I am trying to run the following resultset
Year Quarter Score Name
2012 1 45 ABC
2012 2 22 ABC
2012 3 32 ABC
2012 4 45 ABC
2011 1 45 ABC
2011 2 22 ABC
2011 3 32 ABC
2011 4 45 ABC
into this below format.
2012 2012 2012 2012 2011 2011 2011 2011
Name 1 2 3 4 1 2 3 4
ABC 45 22 32 45 45 22 32 45
I believe this can be done using Pivot, not sure how to get this with two headers (Year +Quarter).
Any thoughts is appreciated
Open in new window
HTHDavid