Hi,

I have these three columns data in which i want to use pivot where with a condition like in the file of Row label should show COULMNA&COLUMNB like pivot should show "JOHNTACK" in pivot

First Name Last Name Location
John tack US
Roul mont UK
Mat hardy Asia