A spreadsheet often has one column per period: q1, q2, q3, q4. That is easy to read and hard to analyze, because the quarter is hidden in the column names. Tidy data has one row per observation: a store, a quarter and a score.
pivot_longer() does the reshaping. Give it the columns to gather, q1:q4 or -store for "everything except store", the name of the new column that holds the old names, names_to = "quarter", and the one that holds the values, values_to = "score".
Missing cells become rows with NA; values_drop_na = TRUE leaves them out. names_prefix = "q" strips the letter so the quarter can become a number with names_transform = as.integer.
Four quarter columns become two columns: the quarter and its score.