I am working on a workflow where I want to select specific rows from a 26 pages data set. I want to select only the description, quantity, unit price and total along with the relevant data. However, I would like to skip all the fluff such as address, dates and so on. Please advise which tool i can use to retrieve only the relevant data from a very big data set.
Illustration
Page 1
XYZ Statement
01/11/49
Bank of America
Street address
City
State
Zip code
Description. Quantity. Unit price. Total
Xyz. 10. 20. 200
ABC. 5. 10. 50
Page 2
TD bank
Street address
City
State
Description. Quantity. Unit price. Total
Xyz. 50 20. 1000
ABC. 5. 20. 100
Page 26
Description. Quantity. Unit price. Total
Xyz. 10. 20. 200
ABC. 5. 10. 50
