How to evaluate cells in datatable and move

[gtownsen]

Good morning, 

I am trying to move a set of records from the past 20 years into a list of "events." Currently, we have the items we performed actions on listed down the first column, and when we performed an action (every 6 years), we put information under the corresponding year (listed down the row). This results in a lot of white space in the table and I would like to make it into a tabular table showing the records so I can more easily manipulate it. Is there any way to do this using Flows or Power Automate for desktop?

Thanks,

GT

[gtownsen]

For reference, this is what the data currently looks like. I want to make it into a list of events that have the year, name of device, area, etc. The end goal is to make a database/dashboard to display all of the devices, when we performed a PM on them in the past, and be able to upload reports to their "file." Any recommendations on how I might accomplish this would be greatly appreciated.