Hi,

I would like to combine multiple columns keeping few columns specific. I am unable to do it just by normal pivoting.

Here is the link I have updated to Box. I have 2 files -
Source_main - contains the source data
target_main - target data



https://app.box.com/s/ns2kci989swgpu8un0q6