Færdiggjort

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

Evner: Databehandling, Excel

Se mere: 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

Om arbejdsgiveren:
( 16 bedømmelser ) Sydney, Australia

Projekt ID: #1056787

Tildelt til:

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 in 0 dage
(143 bedømmelser)
6.4

54 freelancere byder i gennemsnit $45 på dette job

bharanisrihari

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

$30 AUD på 1 dag
(67 bedømmelser)
6.3
nagybatonyi

Please see PMB for showing the immediate way! Regards!

$30 AUD in 0 dage
(62 bedømmelser)
5.7
binaryromel

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

$30 AUD in 0 dage
(93 bedømmelser)
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

$50 AUD in 0 dage
(22 bedømmelser)
5.6
torajiv

Please check a completed sample in your PM

$30 AUD in 0 dage
(35 bedømmelser)
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

$30 AUD in 0 dage
(50 bedømmelser)
5.4
mimirabb

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

$32 AUD in 2 dage
(62 bedømmelser)
5.3
northwolves

see PMB please

$30 AUD in 0 dage
(46 bedømmelser)
5.0
backstage

Let it be done by pro

$250 AUD in 4 dage
(6 bedømmelser)
4.5
pyazlm

Refer to PMB.

$30 AUD på 1 dag
(30 bedømmelser)
4.4
mkdoluweera

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

$30 AUD in 2 dage
(16 bedømmelser)
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

$30 AUD in 0 dage
(7 bedømmelser)
3.8
asr2009

Please See PM

$40 AUD in 0 dage
(3 bedømmelser)
3.4
kaplar90

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

$40 AUD in 0 dage
(5 bedømmelser)
3.8
sriraj1233

PLEASE CHECK PMB

$35 AUD in 0 dage
(5 bedømmelser)
2.7
Abikris

Hi, Please check your PMB for a demo. Kris

$30 AUD in 0 dage
(5 bedømmelser)
2.5
ExcelVBAVeteran

Pls check PMB

$40 AUD på 1 dag
(2 bedømmelser)
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!

$45 AUD på 1 dag
(1 bedømmelse)
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

$70 AUD på 1 dag
(2 bedømmelser)
2.0
Andast

Please check the PM. Thank you!

$30 AUD in 0 dage
(2 bedømmelser)
1.6