Hi Simon,

Thanks for ur input.

But, the no. and name of columns BU1, BU2 etc... and the rows Skill1, Skill2 etc... is also fixed.

I cannot hardcode any values.Hence I cannot use pivot.

Kindly help when all the column names and rows are dynamic.