select 'a' as address, 1 as week1, 2 as week2, 3 as week3

union select 'b' as address, 4 as week1, 5 as week2, 6 as week3

union select 'c' as address, 7 as week1, 8 as week2, 9 as week3

select * from raw_data

unpivot(sales for weeks in (week1, week2, week3))