Scraped Data to Excel Files (100) editing and combining
Budget: $10 – $30 USD
Data Set – 110 Excel Files with up to 1000 lines of data in each file
1. Open file
2. Recover contents (Click Yes within message)
3. Click “Enable Editing”
4. Change all the values in the colum titled “sold amount” from text to numerical
5. Add the file name to each row (note the file name is a date)
6. Convert the file name to date within the row
7. Save the file
8. Combine all files into one dataset (approximately 100,000 rows)
Wish me a happy birthday in your first line of reply to show me you read this
1. Open file
2. Recover contents (Click Yes within message)
3. Click “Enable Editing”
4. Change all the values in the colum titled “sold amount” from text to numerical
5. Add the file name to each row (note the file name is a date)
6. Convert the file name to date within the row
7. Save the file
8. Combine all files into one dataset (approximately 100,000 rows)
Wish me a happy birthday in your first line of reply to show me you read this