Automation and creating report

Onemajor

Hi, Currently I am working on a project where I get excel or csv file from vendors, need to clean that file and then create dashboard. I have more than 25 vendors for different states( for example: CA, LV, NY and other states). Some of the states have 2 vendors some have three. Each of these vendors will send data in different format and different names. I get this data in weekly. 

Now my question is how can I make it work so that for each states I can combine data and create one excel file that will be easy to visualize? Please suggest.  Thank You.

alexnajm

You'll have to read in all of the data and figure out how to align data between all of the vendors - for example if one file has a [Sales] field but another has an [Amount] field, they have to align in the same column. That way, you can bring them all together into one file and use it for your dashboarding