Building a Flow that copies one row of data into another excel document

Hello,

I am rather new to Power Automate and I'm hoping someone can assist me with building a flow. I currently have a successful flow that downloads a CSV file based from data residing in Power BI. This file overrides itself on a daily basis, each time populating with new data based on what the metrics were that given day. A screenshot of this CSV file is seen below - column names (besides the Date column) were scrubbed out given the sensitivity of the data. Unfortunately, the data does repeat itself for ~20,000 rows (I'm only interested in the contents of row 2), which is an unintended outcome but should not have any affect on the requested flow mentioned below.

Now, I want to capture the data in this CSV file historically, but in one single table, so that it looks something like below:

Basically, each day at a scheduled time, a flow would run where it copies cells A2 - I2 from the CSV file and pastes it into the master document, but doesn't override the previous rows and instead pastes into the next available blank row.

I know this may be difficult to follow, so feel free to request any further context from me. I greatly appreciate the help.

Quick Links