in google BigQuery, how to collapse rows based on insertID?

I have logs from stackdriver being loaded into BigQuery and the data looks like this:

Step 1	Step 2	Step 3	Date	InsertID
X			10/26/2021 10:02:22	jd1ge5
	Y
		Z

The code to create the table above is as follows:

select steps, date, insertID from tbl1 where insertID = 'jd1ge5'

Steps 1-3 are from an array. I would like to collapse the data based on insertID so the final output looks something like this:

Step1	Step2	Step3	Date	insertID
X	Y	Z	10/26/2021 10:02:22	jd1ge5

Hope this makes sense.

from Recent Questions - Stack Overflow https://ift.tt/3jEsHSU
https://ift.tt/eA8V8J