En cours

Excel Guru Needs for quick easy work!!

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!!

Compétences : Traitement de Données, Excel

Voir plus : work guru, we excel, to guru, the guru, number guru, in guru, i guru, guru work, get guru, as guru, best way get work, worse, need get excel, format excel, excel guru, copy excel, quick excel, format data guru, needs, excel copy sheet format, excel column copy, quick data, excel copy format sheet, excel rows, quick copy

Concernant l'employeur :
( 16 commentaires ) Sydney, Australia

N° du projet : #1056787

Décerné à :

best4best

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.

30 $ AUD en 0 jours
(92 Commentaires)
5.5

55 freelance ont fait une offre moyenne de 45 $ pour ce travail

bharanisrihari

Hi Mate, Excel expert from Sydney. Please check PM for details. Thanks!

30 $ AUD en 1 jour
(65 Commentaires)
6.4
schandraram

Hello - My bid is for an Excel VBA procedure that will order the data in the desired format. Thank you. Chandra Ram

50 $ AUD en 0 jours
(45 Commentaires)
6.1
binaryromel

########## Excel expert here. Please check PM. #########

30 $ AUD en 0 jours
(68 Commentaires)
5.7
nagybatonyi

Please see PMB for showing the immediate way! Regards!

30 $ AUD en 0 jours
(53 Commentaires)
5.7
FIBIN

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

30 $ AUD en 0 jours
(47 Commentaires)
5.4
mimirabb

I am ready to start work now. Check Pm for details. Thanks

32 $ AUD en 2 jours
(61 Commentaires)
5.3
northwolves

see PMB please

30 $ AUD en 0 jours
(45 Commentaires)
5.0
torajiv

Please check a completed sample in your PM

30 $ AUD en 0 jours
(31 Commentaires)
4.9
backstage

Let it be done by pro

250 $ AUD en 4 jours
(6 Commentaires)
4.5
pyazlm

Refer to PMB.

30 $ AUD en 1 jour
(30 Commentaires)
4.4
muthumuni

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

30 $ AUD en 0 jours
(7 Commentaires)
3.8
kaplar90

Please check PMB, I already know how to automate this for you

40 $ AUD en 0 jours
(4 Commentaires)
3.9
mkdoluweera

Hello Sir, Ready to start your project, having similar experience in the same field. awaiting for your reply

30 $ AUD en 2 jours
(10 Commentaires)
3.6
asr2009

Please See PM

40 $ AUD en 0 jours
(3 Commentaires)
3.4
Abikris

Hi, Please check your PMB for a demo. Kris

30 $ AUD en 0 jours
(5 Commentaires)
2.5
ExcelVBAVeteran

Pls check PMB

40 $ AUD en 1 jour
(2 Commentaires)
2.3
sriraj1233

PLEASE CHECK PMB

35 $ AUD en 0 jours
(3 Commentaires)
2.0
neelu7779

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

70 $ AUD en 1 jour
(2 Commentaires)
2.0
sebrosse

Hi, this is pretty straightforward. I can build a robust macro to automate this within a very short period of time. Ready to start!

45 $ AUD en 1 jour
(1 Commentaire)
1.8
ashutoshlovey

ready to start see pm ..

50 $ AUD en 2 jours
(1 Commentaire)
1.7