before:
  table A1:D5
  series 1: =SERIES(Sheet1!$A$2,Sheet1!$B$1:$D$1,Sheet1!$B$2:$D$2,1)
  series 2: =SERIES(Sheet1!$A$3,Sheet1!$B$1:$D$1,Sheet1!$B$3:$D$3,2)
  series 3: =SERIES(Sheet1!$A$4,Sheet1!$B$1:$D$1,Sheet1!$B$4:$D$4,3)
  series 4: =SERIES(Sheet1!$A$5,Sheet1!$B$1:$D$1,Sheet1!$B$5:$D$5,4)
table grown by Excel as typed
after:
  table A1:E5
  series 1: =SERIES(Sheet1!$A$2,Sheet1!$B$1:$E$1,Sheet1!$B$2:$E$2,1)
  series 2: =SERIES(Sheet1!$A$3,Sheet1!$B$1:$E$1,Sheet1!$B$3:$E$3,2)
  series 3: =SERIES(Sheet1!$A$4,Sheet1!$B$1:$E$1,Sheet1!$B$4:$E$4,3)
  series 4: =SERIES(Sheet1!$A$5,Sheet1!$B$1:$E$1,Sheet1!$B$5:$E$5,4)
