- Pivot table is correctly representing your numbers. Your data is one dimensional hence the given layout.
- Yes and no. Your example is table and not a pivot table meaning you need to transpose your data first and create a table in looker studio. However, you will need to add each week as separate column which is probably not best idea..
- You can introduce new dimension to your data but this wont also produce result you require as its going to correctly pivot your data and show all in one row for your dimension.
I suggest try changing your habit from scrolling horizontally to pivotally.
I understand it may be challenging at start but BI are bit different from Spreadsheets.
Regards
Arkady Zagdan