Import["C:\Users\njs\Documents\Computing\Software\Mathematica\

myData = Flatten[
    MapIndexed[{Sequence @@ #2, #1} &,
    Import["/Users/nick/Documents/Mathematica/sampleData3.xlsx",
    {"Data", 1, {2, 3, 4, 5}, {2, 3, 4, 5}}
    ], (* <-- close Import. NOTE: {"Data", 1, {2;;5},{2;;5} did not   work *)
    {2}],  (* <-- Close MapIndexed *)
    1]  (* <-- Close Flatten *)

data = Flatten[Import["sampleData3.xlsx", "Data"], 1];

data//TableForm

data[[1]]
{0., 1., 2., 3., 4., "", "", "", "", ""}

data[[All, 2]]
{1., 11., 31.}