How to add Blank row, before row value chages

Help Activities
, ,
1

Hi, I need to add the blank row , based on col 0, row value changes, need to add blank row , if value in col0 changes ,

sam
SampleFile.xlsx (9.9 KB)
ple file attached

TIA

2

Hi,

Can you try the following sample?

image
image788×630 24.6 KB

arrRowIndex = dt.AsEnumerable.Where(Function(r) not String.IsNullOrEmpty(r(0).ToString)).Select(Function(r) dt.Rows.IndexOf(r)).Skip(1).OrderByDescending(Function(i) i).ToArray()

Sample20231214-5L.zip (10.2 KB)

Regards,

1 Like
3

Thank you @Yoichi , Somehow I am not aware of invoke method, I will study on it now :slight_smile:

You solution worked for me.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.