Hello, [image] I have data table as above. I need every cell after each empty cell (In this case AD21 and AD31). I thought of splitting data table base on empty cell and then taking first cell of each splitted data table but I couldn’t split data table base on empty cells. I couldn’t find any exa…

Detecting Empty Rows in Data Table

ppr (Peter Preuss) November 18, 2020, 9:24am 5

find starter help here:
DT_Slice_ByBlankRows.xaml (9.9 KB)

Let us know your feedback

Split DataTable