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

Færdigheder: 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, excel copy sheet format, excel column copy, quick data, excel copy format sheet, excel rows

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
(92 bedømmelser)
5.5

55 freelancers are bidding on average $45 for this job

bharanisrihari

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

$30 AUD på 1 dag
(65 bedømmelser)
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 in 0 dage
(45 bedømmelser)
6.1
binaryromel

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

$30 AUD in 0 dage
(68 bedømmelser)
5.7
nagybatonyi

Please see PMB for showing the immediate way! Regards!

$30 AUD in 0 dage
(53 bedømmelser)
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 in 0 dage
(47 bedømmelser)
5.4
mimirabb

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

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

see PMB please

$30 AUD in 0 dage
(45 bedømmelser)
5.0
torajiv

Please check a completed sample in your PM

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

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

$40 AUD in 0 dage
(4 bedømmelser)
3.9
mkdoluweera

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

$30 AUD in 2 dage
(10 bedømmelser)
3.6
asr2009

Please See PM

$40 AUD in 0 dage
(3 bedømmelser)
3.4
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.3
sriraj1233

PLEASE CHECK PMB

$35 AUD in 0 dage
(3 bedømmelser)
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 på 1 dag
(2 bedømmelser)
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 på 1 dag
(1 bedømmelse)
1.8
ashutoshlovey

ready to start see pm ..

$50 AUD in 2 dage
(1 bedømmelse)
1.7