It would be greatly appreciated if someone can point me in the right direction on how to export all list data from a site to an excel file. Below is what the desired output should be. I've looked online and can't seem to find a good solution for this. I'm looking into a web part but any advice would be appreciated.
*Edit - Site Owners are going to be using this to generate the reports on their own.