Mar 28 2020 11:44 AM
On the left is a table documenting individual plants of a single species (B) in different plots. There is also a Type designation for each plot. I would like to create a new table which lists each plot just once along with the number of plants found in each plot and the Type designation for the plot. Suggestions?
PLOT | SPECIES | TYPE | MASTERID | NO. B | VEG88 | |
8 | B | 3 | 8 | 2 | 3 | |
8 | B | 3 | 10 | 2 | 2 | |
10 | B | 2 | 11 | 3 | 4 | |
10 | B | 2 | 13 | 5 | 3 | |
11 | B | 4 | 14 | 3 | 2 | |
11 | B | 4 | 15 | 1 | 1 | |
11 | B | 4 | ||||
13 | B | 3 | ||||
13 | B | 3 | ||||
13 | B | 3 | ||||
13 | B | 3 | ||||
13 | B | 3 | ||||
14 | B | 2 | ||||
14 | B | 2 | ||||
14 | B | 2 | ||||
15 | B | 1 |
Mar 28 2020 12:39 PM
SolutionMar 28 2020 12:51 PM
PivotTable will work, especially if TYPE are numbers.
Mar 29 2020 09:02 AM
Mar 28 2020 12:39 PM
Solution