Data Modeling/Filtering Advice Needed

wina-sunbelle , In Power query Unpivot Other columns (Other than Week Start, Week End, Week Num)
Split by Delimiter , from end -> 2 columns . That will give Pizza Hut and Year separated 

Now you can create a Matrix visual with Type (Pizza Hut and Dominos) , and FY

if you have double  header refer 
https://youtu.be/1e16oHv9kTk

wina-sunbelle 

Hi, Your expected result cannot be completed in Power Query, but there is a way in reporting. 

Once you are done normalizing data in Power Query with the approach provided in earlier post. 

Select matrix and use 'outline' for layout under 'Layout and style presets'. Place the right fields in right rows, columns and values as in below picture.