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!!
55 freelancers are bidding on average $45 for this job
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
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