How to pivot this data?

Question

Name.  Status.  ID.   Country.   City.              Town

Ben.       Active.   १.    US.           Chicago.        X

Ben      inactive.   १.    Japan.     Osaka.           Y

Into

Active.      Inactive    active.      Inactive

ID.     Name.   Country.     Country.    City.           City

१.       Ben.        US.             Japan.      Chicago.  Osaka

Ofcourse there will be १००s of rows, १ name and ID and two status for each but currently in vertical format, I want it status wise in horizontal format and १ row for each ID

Not able to get the right way using transpose or cross tab

danilang · Accepted Answer

Hi @Isha_Gupta

You can't do this in a single tool.

You have to build the column names using transposed data and then crosstab and clean the column names

Dan

binu_acs · Accepted Answer

@Isha_Gupta try