I need the data in this Excel file that is in the vertical format, transpose to a horizontal format. The data in each data set is separated by a blank line. All data needs to be lined up with the correct heading. 98% of the file can be transposed in Excel with short cuts. Project has already been started. Review the attached file and you will see that some work has already been done. You will see what needs to be done next.
Follow these shortcuts:
1. Highlight each data set. All data sets are separated by a blank line.
2. Control "C"
3. ALT "E"
4. ALT "S"
5. ALT "E"
6. Click on row "E" of the Bid Number for the data set.
7. Click "OK"
Go to the next data set.
Due the the repetition of this project I need someone who has an eye for details. All data that is transposed needs to be in the correct column. There will be times that you need to move the data over to get the other cells lined up correctly. Most data sets can by moved to horizontal by using the short cuts.
I need this done in the next 48 hours.
When you have 25% of the file complete, send me a copy of your work for review. If it all looks good, I will send it back for completion.
Once complete, send me the data file for review. If there are corrections that need to be made, I will send it back. If all is correct I will release funds for payment.
Décerné à :
16 freelance ont fait une offre moyenne de 73 $ pour ce travail
I've completed many similar projects successfully. Well versed with Excel, and fast data searching, extracting and inputting skills. Can start immediately. Details in Pm. Thank you.