Data filter

[mlellison (Max Ellison)]

Hi @purnima_mandan

I see, below please find my method,

1.) Create a variable (list of string) to store all column names, lets name it ColumnNameList
2.) Wrap for each excel row with for each ColumnNameList

3.) Inside for each excel row body, use if activity
if cell = Nothing, assign column name to cell

Below please find the xaml file
Test.xaml (18.0 KB)