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

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

The expected result is highlighted in yellow. In this example, column D would show OUT for D18:D48 and IN for D56:D114.
Status can be either way and only shows up in one table or the other. The date time is a status change time.

Sorry, didn’t realize the yellow cells were empty.

Something like below?

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Both work flawlessly, thanks you for your time!

Curtis