“ :noitagergga lanoitidnoc a gnisu .g.e ,ydaerla tovip nac uoYhttps://stackoverflow.com/questions/50796224/pivot-rows-in-big-query . Client tools such as Sheets, Excel, Data Studio, etc. are almost always in a better position to pivot the data returned by BigQuery since if you want to do it in a single BigQuery query, you need to provide the list of values and column names to pivot. ”