Data Transformation to desired Format

[DataPirate26]

Hi everyone, 

I have a required dataset in which Data is given in a specific format. The Headers which have US, CA denotes the Country US and Canada. 

I want to transform the data in the given desired format. Yes and No denotes if the review has been completed. 

I want to represent the data in the given Desired output format. where for which Territory the review has been completed is separate by a Comma. 

Note: It needs to be dynamic ( Along with US, CA, several other countries can also come in the headers in future which needs to be considered.)

Screenshot attached for reference.

Please guide me to Get the desired format

[DataPirate26]

@binuacsAny go on this ? Can you guide how to transform the data in the desired format?

[DataPirate26]

Have Resolved It now.