I have the initial data and query like this: Testing Data

With query, is it possible to make data like in the picture?

This is the data link:

I tried few solutions found in Google, so far they don't work. Basically it's to rewrite the same data and transpose the combination. Blank combination will be ignored.

Thank you very much