How to pivot this data?

[Isha_Gupta]

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 solution]

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 solution]

@Isha_Gupta try