Hello! I have a bit of a problem... I have over 30 files that have either one or another format (based on time).
I am wanting to standardize the data to input into powerBI. I have all of these files in on location on a SharePoint site, but need to get them all in the same format to be able to combine them in PowerBI. I'm not sure what the best way to go about this is.
Attached are two files that are the two different formats (different by a few columns having to do with COVID).
Any advice/tips on how to combine this data is MUCH appreciated! I would really love to not have to manually manipulate each file.
