Terminé

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

en voir plus : work guru, we excel, to guru, the guru, number guru, in guru, i guru, guru work, get guru, get a guru, as guru, best way to get out of work, worse, need to 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

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.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 0 jours
(143 Commentaires)
6.4

54 freelance font une offre moyenne de $45 pour ce travail

bharanisrihari

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(67 Commentaires)
6.3
nagybatonyi

Please see PMB for showing the immediate way! Regards!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(62 Commentaires)
5.7
binaryromel

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(93 Commentaires)
6.0
schandraram

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(22 Commentaires)
5.6
torajiv

Please check a completed sample in your PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(35 Commentaires)
5.4
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(50 Commentaires)
5.4
mimirabb

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(62 Commentaires)
5.3
northwolves

see PMB please

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(46 Commentaires)
5.0
backstage

Let it be done by pro

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(6 Commentaires)
4.5
pyazlm

Refer to PMB.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(30 Commentaires)
4.4
mkdoluweera

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(16 Commentaires)
4.1
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(7 Commentaires)
3.8
asr2009

Please See PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(3 Commentaires)
3.4
kaplar90

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(5 Commentaires)
3.8
sriraj1233

PLEASE CHECK PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(5 Commentaires)
2.7
Abikris

Hi, Please check your PMB for a demo. Kris

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(5 Commentaires)
2.5
ExcelVBAVeteran

Pls check PMB

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(2 Commentaires)
2.2
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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(1 Évaluation)
1.8
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(2 Commentaires)
2.0
Andast

Please check the PM. Thank you!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(2 Commentaires)
1.6