Hi Alex,
If the spreadsheet is the source of the data then you can generate the final lists like this. I created the attached AlexData.xlsx for testing.
{listAfinal, listBfinal, listCfinal, listDfinal} =
Import["~/Downloads/AlexData.xlsx", {"Data", 1, 5 ;; 9, 2 ;; 5}] // Transpose // Reverse;
{listAfinal, listBfinal, listCfinal, listDfinal} // Column
(*
{28.,35.,40.,43.,44.}
{20.,28.,35.,40.,43.}
{18.,20.,28.,35.,40.}
{13.,18.,20.,28.,35.}
*)
Attachments:
