Repeat text in a range of cells in between defined cells in another column?

[DJDRU]

Hello,

I have a file connected to a data source that contains a couple tables separated by blank rows and specific text. The first table shows check out times and the second check in. I am attempting to add a column to this data specifing OUT or IN. Ref the attached example: The Equipment Check Out Text is always present so I was thinking to use this as a starting point, then use a do until Equipment Check In text to add this, but I am struggling with defining the starting Row-Col parameter, and then repeating this for the IN cells. I am using index match functions to retrieve the data for further use.

I originally had this broken up into two tables, which made it a lot easier, but the Report generated date and time information is separate, making me have three separate table queries. I would also add that the two tables are dynamic and that one can be only as many rows as the row count of the tables combined.

Any help is greatly appreciated.

Thanks,
Curtis