Excel Data

Copper Contributor

I have 76 spreadsheets with about 50,000 rows of data each. Any suggestions for analyzing this data? 

1 Reply
Excel PowerQuery or Power BI - Use the Get Data/From File/From Folder (put the files into OneDrive or Sharepoint). https://support.office.com/en-us/article/combine-files-in-a-folder-with-combine-binaries-power-query...