Read excel file with empty rows

I have an excel file, need to read the file and get separate data corresponding to col3 i.e L or P.
Need to get the last row index of the table corresponding to L and P.

Ex: If I have a record with col3 as L, then need to add record at row 14th and if I have a record with col3 as P then need to add the record at row 21.

I have attached Excel file
How to achieve this. TIA
New Microsoft Excel Worksheet.xlsx (8.7 KB)

Hi @MEGHA_cs ,

So your expected output will look like this correct?

image

Regards,
Vinit Mhatre

No, it should look like this

Hi @MEGHA_cs ,

Please find the following process for your reference, and let me know if you have any questions…

Main.xaml (25.1 KB)
New Microsoft Excel Worksheet.xlsx (9.9 KB)

Regards,
Vinit Mhatre

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