Thank you so much for the help. (ALL OF YOU!!!)

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Nevermind, datatypes need to be the same! Any way I can do this without making a temp table?

I am getting the error 

The type of column "COL4" conflicts with the type of other columns specified in the UNPIVOT list.

When running :

J Livingston, Thank you so much.

Column order does not

Thank You.

I feel really stupid, THANK YOU.

I am speechless. THANK YOU SOOOOO MUCH.

The table contains three columns. A B C are always separated by a pipe.

Thank you so much!

Thank you!

Is it possible to do this without using xp_cmdshell?

My dba's will not allow it :/