I input data using wild card to pull in all the files from a location. There may be 100+ files each day and up to this point the data I needed started on line 10. That was easy enough to solve for.
Recently, I was made aware of a new file (same columns) but data starts on line 8 and my workflow will blow up if this was the first file for the day. I need my data to dynamically start where [f1] = “Specialist Name” and the sample tool is not that specific. I started with a formula to tag a new column where [f1] = “Specialist Name” , but can’t figure out how to only delete the leading rows and not all of them.
Any ideas or other ideas for solving this?
