Hi Jeff,

Sorry for the late reply. I was involved in another project and was not able to come back to this.

And thank you for your eagerness to help.

I was...

Thank you Jeff.

I was able to use the unpivot command but only with one column not translated.

What I did after that was to join it to the original table to...

I was hoping that a pivot command will be able to do that.

Thank you.

It is simple if the columns are less than 10. But what if the columns REF* are 100 or more?

Is there a better way of coding?