How best to structure matrix style data from Excel

bd4 the best is to unpivot the data:

transform data -> select team and date column -> right click -> unpivot other columns

it will give you two more columns, called Attribute and Value, and rename these as you see fit. Close and apply

And now you can filter by attribute or team or date and visualize the value of each question the way you want.