Forum Discussion

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    deadshot1680 

    That's job for Power Query

    1) query the table with column numbers, in editor add prefix "Column". Let say that is table Columns which has only one column Number

    2) query csv file and add step Table.SelectColumns(Source, Columns[Number])

    3) land result into Excel sheet

Resources