CODEWITHSUNDEEP
sqlpython-3.xgoogle-bigquerytransposebigquery-udf
Navin
Navin

Reputation: 23

BigQuery Transpose on multiple Columns

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

Upvotes: 0

Views: 114

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173121

Consider below approach

enter image description here

if applied to sample data in your question - output is

enter image description here

Upvotes: 1

Related Questions