I have pasted all the information that needs to be put into the spreadsheet into a text document. This is all copy and pasting.
The information will need to be taken from the text document and put into the correct cell. Not all the information is on the text document, but can be found from these two sites:
I will also need you to get a photo for each contestant on each show from either of the sites. You will need to rename each photo with the season number and episode number, followed by which contestant they were in order (c1, c2, c3, c4), the contestant name, and product.
I will need these photos compressed (.zip) and sent back to me with the completed spreadsheet.
The name of that photo will then need to be pasted into the spreadsheet (pasted into Column S)
I understand not all information (like city of the company/product) is available, but I will need you to do your best to fill in all cells.
All the information can be found in the zip file I am attaching. there is the info folder which includes the spreadsheet and text, and the photo folder which includes the photos.