How to read the Unstructured data from the excel

Help Activities
, , , , , ,
1

HI All,
Could you please help me how to read the following excel sheet ?
TestCaseSheet.xlsx (47.4 KB)
Happy Automation .
@ppr
@Yoichi
@ushu
@vishal.kp
@supermanPunch
@Anil_G
@rlgandu

regards .
@kmaddikatla

2

Hi kmaddikatla,
The first thing that you need to do is organize your format. Try to do a simple format. Delete the columns that you dont need them.

image
image1641×944 59.5 KB

NOTE: If you organize your format is very simple to extract the information with a simple Read Range Workbook.