How to use For Each to go through a set of columns in a data table to extract data based on set criteria

Help
1

I am trying to get data from a set of columns in a spreadsheet and consolidate it to a single column. The data is variable and I need to add criteria so that it only returns certain values. The picture below is my data set. The values to the right that are incomplete should not be returned. I was able to get a clean set of data from a single column, but I can’t seem to get a clean set if I try to read multiple columns into a data table, so I thought maybe I could do a for each column and have each column data add to a data table to get my list. Any ideas?

image
image1625×661 14 KB

2

Hi @alicat0818

Are you using DataScrapping

Thanks
Ashwin.S

3

I wasn’t because it’s an excel spreadsheet and I was using the excel read range functionality.