Hi.
I have a table of data something like:
Taxon Species Index No. individuals
taxon1 species1 35.63 15
taxon2 species2 28.22 7
taxon3 species3 25.94
species4 28.52 6
species5 21.35
species6 26.64 18
taxon4 species7 22.94 26
I would like to generate a table according to No. Individuals where all the blanks are excluded - i.e. only the rows with data in are included. At the same time, I would like the taxon name to included in the final table. With the data above, if I filter according to No. Individuals to exclude blanks, I would generate a table that looks like:
taxon1 species1 35.63 15
taxon2 species2 28.22 7
species4 28.52 6
species6 26.64 18
taxon4 species7 22.94 26
In other words, the third and fourth rows in the 'filtered' table do not have the taxon3 name.
I would like the table to look like:
taxon1 species1 35.63 15
taxon2 species2 28.22 7
taxon3 species4 28.52 6
species6 26.64 18
taxon4 species7 22.94 26
I know that I can copy the taxon name for every row of data but I am hoping to avoid this as I would like the taxon name to appear only once in column 1. I am hoping to avoid the table looking like:
taxon1 species1 35.63 15
taxon2 species2 28.22 7
taxon3 species4 28.52 6
taxon3 species6 26.64 18
taxon4 species7 22.94 26
Where 'taxon3' is repeated twice.
Any help would be greatly appreciated.
Jenny
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have a table of data something like:
Taxon Species Index No. individuals
taxon1 species1 35.63 15
taxon2 species2 28.22 7
taxon3 species3 25.94
species4 28.52 6
species5 21.35
species6 26.64 18
taxon4 species7 22.94 26
I would like to generate a table according to No. Individuals where all the blanks are excluded - i.e. only the rows with data in are included. At the same time, I would like the taxon name to included in the final table. With the data above, if I filter according to No. Individuals to exclude blanks, I would generate a table that looks like:
taxon1 species1 35.63 15
taxon2 species2 28.22 7
species4 28.52 6
species6 26.64 18
taxon4 species7 22.94 26
In other words, the third and fourth rows in the 'filtered' table do not have the taxon3 name.
I would like the table to look like:
taxon1 species1 35.63 15
taxon2 species2 28.22 7
taxon3 species4 28.52 6
species6 26.64 18
taxon4 species7 22.94 26
I know that I can copy the taxon name for every row of data but I am hoping to avoid this as I would like the taxon name to appear only once in column 1. I am hoping to avoid the table looking like:
taxon1 species1 35.63 15
taxon2 species2 28.22 7
taxon3 species4 28.52 6
taxon3 species6 26.64 18
taxon4 species7 22.94 26
Where 'taxon3' is repeated twice.
Any help would be greatly appreciated.
Jenny
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>