I am trying to pivot a row and cant seem to figure out how. I am trying to combine two colums into one column with two rows. At first The names were all contained in one column but I wrote a function to spilt them up into seperate columns.
Here is a sample of the current data
This is what I want
This is something I do often so a function would be ideal. Any suggestions?
asked Mar 30 '12 at 01:14 PM in Default
Based on your example, you just need a UNION :
answered Mar 30 '12 at 01:17 PM
Kev Riley ♦♦