Maggie Barr
Board Regular
- Joined
- Jan 28, 2014
- Messages
- 188
Hello, and thank you for your time in advance if you can help.
I am working on a PC in excel 2013. I have a table of breeding bird data with codes that I need to create a summary table from. I am unsure of the most efficient way to do this and have spent many hours adjusting data, trying formulas, and using pivot tables to see what I can do, to no avail as of yet. I think that perhaps a formula would be the best way, but I am unable to figure out the extent of the commands needed. I have included a link to the data set below which has the blank tables to the right that I need to populate with the data summary. In short, I need to take data for each of three categories Confirmed, Probable, and Possible, and provide the data for each from 1-3 in order that they are in the column header. Below is an example of the data for just the Confirmed, but please see the link to the data set to get a better idea. So, for instance, in the Alder Flycatcher & American Bittern below, for the Confirmed breeders portion of the data, anything with a 1 needs to go in the 1 category with the codes "column headers" in order as they fall, separated by a ",". See output example below this.
DATA FORMAT
<tbody>
</tbody>
AND turn it into a summary like this for output:
<tbody>
</tbody>
I am working on a PC in excel 2013. I have a table of breeding bird data with codes that I need to create a summary table from. I am unsure of the most efficient way to do this and have spent many hours adjusting data, trying formulas, and using pivot tables to see what I can do, to no avail as of yet. I think that perhaps a formula would be the best way, but I am unable to figure out the extent of the commands needed. I have included a link to the data set below which has the blank tables to the right that I need to populate with the data summary. In short, I need to take data for each of three categories Confirmed, Probable, and Possible, and provide the data for each from 1-3 in order that they are in the column header. Below is an example of the data for just the Confirmed, but please see the link to the data set to get a better idea. So, for instance, in the Alder Flycatcher & American Bittern below, for the Confirmed breeders portion of the data, anything with a 1 needs to go in the 1 category with the codes "column headers" in order as they fall, separated by a ",". See output example below this.
DATA FORMAT
Species | Confirmed | |||||||||||
NY | NE | FS | FY | CF | FL | ON | UN | DD | NB | CN | PE | |
Alder Flycatcher | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | |||
American Bittern* | 2 | 2 | 3 | 2 | 1 | 3 | 3 | 3 | ||||
<tbody>
</tbody>
AND turn it into a summary like this for output:
<tbody> </tbody> | ||||||||||||||||||||
https://www.dropbox.com/s/xc3avm3c02cwnri/Template for Mr. Excel question.xlsx?dl=0 I would appreciate ANY advice or assistance on this. Thank you for taking the time to read this post and assisting if at all possible. Sincerely, Maggie |
<tbody>
</tbody>
Last edited: