Completed

Looking for excel expert to format spreadsheet

Hello i am looking for a solution in Excel that will auto create rows based on info within certain cells in the row. So i have en ecological dataset with waterbird individuals but i need to assign 8 different rows for waterbird presence based on info from 1 row. I have attached a sample spreadsheet that shows how my original dataset looks like and the end product of what i need my spreadsheet to look like.

Basically i have a Raw_Data sheet which i need to be formatted into an Intended_Output sheet. I have data from 10 individual birds (Bird 1 - Bird 10) and i have noted their presence or absence during times of the day, tidal patterns etc. What i need is to build include presence absence rows for each individual for each calendar day regardless if they were presence or absent. You can see how the output would look like in the Intended_Output sheet. So for example if BIRD 1 is present during the night on the 17th of June and BIRD 3 is present both in the day and night then BIRD 1 would have a presence of 1 in the Night and 0 in the Day whilst BIRD 3 would have presence of 1 during both day and night and all other BIRD would have presence of 0 in both Day and Night. You can see from the Raw_Data sheet that only presence or absence is recorded for an individual when there has been a presence. What i need is to show also the absence for each individual on each day. I guess a formula that builds additional rows based on information in certain cells is the way forward.

I am wondering if you could build a formula to automate this as i have 20,000 rows to format.

Skills: Excel, Data Entry, Data Processing

See more: excel macro format phone numbers, toronto excel expert job, converting excel label format, excel expert financial models, looking quickbooks expert, excel log chart spreadsheet, excel label format, good looking excel format, looking excel expert create multiple macros, great looking excel spreadsheet, expert format excel, looking for excel expert in gastonia, excel expert cost audit format, looking for an excel expert, looking for excel expert, looking for excel expert in brussels, looking for excel expert in richmond virginia

About the Employer:
( 1 review ) Dumaguete, Australia

Project ID: #20361886

Awarded to:

MimiFL

Hi, this is definitely possible, but not with formulas, for this you need macro (VBA code). Basically you will have a button and once pressed you will get the Output sheet, exactly as your sample, based on the data tha More

$50 AUD in 1 day
(478 Reviews)
6.9

10 freelancers are bidding on average $41 for this job

datakillers

Hi, I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my c More

$30 AUD in 1 day
(230 Reviews)
7.0
Taisho

Hello, you will need a VBA macro to generate the output as described. I will assign it to a button. While the presented Excel file output doesn't directly correspond to the raw data, it shows the concept and I underst More

$40 AUD in 1 day
(62 Reviews)
5.2
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More

$30 AUD in 1 day
(25 Reviews)
4.6
Aishwaryakumari

Dear Client, I can do this Job. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and e More

$50 AUD in 1 day
(18 Reviews)
3.3
Taanju

I want to do this work.I am very expert on this [login to view URL],if you give me a chance to prove my best,i am very greatful to you.

$40 AUD in 7 days
(0 Reviews)
0.0
josolano09

More than 10 years of experience in assisting with Data projects, excellent results and performance

$55 AUD in 7 days
(0 Reviews)
0.0
johnchidinma4

Ok am ready to do the work . Let's begin

$30 AUD in 3 days
(0 Reviews)
0.0
mohamed20ouka

I work with PDF and Excel constantly and I would be more than glad to help you with this project. I believe I can do a great work for you. I understand the value of your time and I will have the project finished when y More

$40 AUD in 1 day
(0 Reviews)
0.0
Akaexcel62

This is the kind of work I do daily. I am the best candidate for this job offer. You just need to give the chance so that I will show you that I am simply the best for this. Furthermore, I have the feeling that this wi More

$40 AUD in 7 days
(0 Reviews)
0.0