Compare Proposal

Nothing to compare.

Excel Data cleansing

  • Posted at : 1 month ago
  • Post Similar Project
1000

Budget
114
Proposals
812
Views
Awarded
Status
Skills Required

Posted By -

PL

5.0
Projects Posted : 4
Projects Paid : 4
Services Purchased : 0
Total Spent :
49
Feedbacks : 50 %

Project Details show (+) hide (-)

Information on four different heads is available in a single column in different rows which needs to be transposed to a single row in different columns. About a thousand records are now in about 5000 rows, which need to be rearranged in a single row each. Unwanted data needs to be deleted. Basically, one record will require 1/2 cells of copy/paste and 2/3 cells of delete.