if i am reading this correctly, you are looking to take a 3 column spreadsheet and make it into one column in your data flow. if that is the request, that is simple enough.
create an Excel source connection to your spreadsheet and pick out the columns to import. then add the Unpivot transformation task to your data flow specifying the same column name for each of the fields.
the result will give you a data flow where all of the columns you selected are returned in one column in many rows.