Just a thought if you haven’t explored Get & Transform in Excel, it is pretty magical once you wrap your head around it.
We had a member do a nice intro: IUG 2021 Virtual Presentation: Excel: Love it or Hate it? Tips & Tricks using Excel's Get & Transform
But there are also lots of other tutorials out there on the Internet.
Not that you want to reinvent the wheel, but if someone else is looking and thinking about it, it might be a good alternative option for them.