How do I shift row values on a datatable if row and column index positions are missing?

Help Activities
, , , , , ,
1

Hi All,

I have a datatable where I need to move Values from Row(7)(49) to Row(14)(49) if any cell from Row(0)(50) to Row(6)(50) is not empty.

I want to move the values highlighted in the green box to the top of the column if the values highlighted in yellow are not empty.

image
image1136×514 16.6 KB

I have attached my workflow below. I am getting an error when I assign values to the 49th column.

Please help

2

Replacing row index values if different column values are missing.xaml (10.7 KB)

3

Hi @sharon.palawandram ,

Could you also provide the Input Excel Sheet ? It would be more helpful to create the Logic if you will provide the Expected Output in the form of Excel Sheet after Shifting rows.