I need to get data in an excel spreadsheet re arranged in a certain format..
We have 12 "Sets",
In Each "Set", a respondent chooses their BEST & WORST "Bundle" (This is a choice out of 3)
(The Bundles are numbered 1-9)
All you need to do is work out a way to copy the BUNDLE NUMBER into the respective Best or Worse Column..
And then re arrange that data into a format being (RespondentID, Set #, Best bundle number, Worse bundle Number THIS IS SHOWN ON SHEET 2)
I have the original data on Sheet 1 and so the output needs to be put into the format on sheet 2..
I have completed the first 3 rows in sheet two as an example
this needs to happen ASAP.. only experienced with excel apply!!
I am an Excel expert. Please take a look at PMB for 100% accurate sample output of your project and my reviews for Excel projects.
54 freelance font une offre moyenne de $45 pour ce travail
Hello - My bid is for an Excel VBA procedure that will order the data in the desired format. Thank you. Chandra Ram
Hi, I have completed the project. Please see my private message with the trial version attached. I can deliver the project in the minimum time if awarded to me. Thanks Fibin
Hello Sir, Ready to start your project, having similar experience in the same field. awaiting for your reply
Dear Sir Kindly see the PMB. There I have Submit 100% completed product for your review. (Created by MS Excel Macro 2003 and MS Excel Macro 2007 - 2 files) Thank you Best regard muthumuni
Hi, this is pretty straightforward. I can build a robust macro to automate this within a very short period of time. Ready to start!
hi This is a easy job for me. I will deliver it in a single day. Please check the PMB for sample work. Thanks. regards Neelesh