Organising complicated multiple column data into row data

Help Studio
, ,
3

Hi @Wei_Ji_Kwok

Note: All the column headers should have a unique name

  • Read Range and add the properties Add headers if unique row headers else disable add headers
  • You can try with Filter datatable activity and use output columns and select on Keep and add your column names if you have unique headers else add the index
    image
    image646×521 16.1 KB

    image

You can also try this expression to get only those columns if you have unique column headers

dt.DefaultView.ToTable(False,"Col1","Col2","Col3")

Hope this Helps

Regards
Sudharsan