thanks for the reply, yeah the problem is one column have 2 data that i need to create separate.
I need to make new column to store Priority1,2
I thought if i used Pivot will solve the issue, but i still confused how to get that.