Home > front end >  return product name in new column for each row based on if an individual product column in each row
return product name in new column for each row based on if an individual product column in each row

Time：03-16

I am receiving sales data in a format like:
enter image description here

I'd like to at least get in the format of:
enter image description here


Or even better:
enter image description here

I'm looking to do this in Google Sheets, but if that's not an option I'm looking to use bigquery.

Thank you.

CodePudding user response：

Consider below options (BigQuery)

enter image description here

with output

enter image description here

Or even better:

enter image description here

with output

enter image description here

Page link：https//www.codepudding.com/frontend/336857.html

Prev:BigQuery - concatenate array of strings for each row with `null`s
Next:BigQuery - concatenate array of strings for each row
  • Related

About Us:  Contact Us      Terms of Service       Privacy Policy

Copyright © 2010-2023，Powered By CodePudding