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]: