Home > OS >  How do I manipulate a messy table into structured data in google sheets?
How do I manipulate a messy table into structured data in google sheets?

Time:03-28

I have a table with columns "Advertiser", "Product", "Week 1", "Week 2", "Week 3" with a sales value in each "Week" entry row and would like to convert into a structured table that converts all the week columns into 1 and having the sales value for that corresponding week in a separate column, thus effectively creating a single row for each sales value.

Please see the image URL below clearly showing current vs desired output: [1]: enter image description here

  • Related