BigQuery Transpose on multiple Columns

Question

Need Help with below Transformation in BigQuery, Here CMPTTR NAME will increase dynamically from 2 to n:

Answer 1

Consider below approach

if applied to sample data in your question - output is