Read excel file with empty rows

Help Studio
, ,
1

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)

2

Hi @MEGHA_cs ,

So your expected output will look like this correct?

image

Regards,
Vinit Mhatre

3

No, it should look like this

Capture
Capture495×578 8.53 KB

4

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

5

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