Select Remove Other Columns from the drop down menu.Hold the Ctrl key and left click on the column headings to select them. Select the two columns you don’t need ( Content and Name).These are not needed for the purposes of combining data. The From Folder query will include a lot of data such as file extension type, date modified, file location, etc. Step 2: Remove data columns that aren’t needed Check these are the correct files and folders. A preview of the import data will appear.Select the folder path of the files you want to import.Ĭheck the preview data to ensure it is in the correct folder and files.Select From Folder in the drop down menu.Each sheet contains the sales for a given salesperson from the country and is named with the sales person’s name.Īs you can imagine, aggregating the data manually would be very time-consuming as the number of files and sheets grows. Ireland.xlsx, England.xlsx, Luxembourg.xlsx, and Canada.xlsx).Įach file has several sheets with different data in the same format. Each file contains the sales for a given country and the files are named according to which country the sales data is from (i.e.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |