Brandonfromsingapore
New Member
- Joined
- Jan 5, 2012
- Messages
- 38
Hello, i have an excel file (sheet 1 only) that has data for 3 columns and multiple rows. The student number (ie name) are at column 1. The header is row 1.
The name of fruits (ie apple, lemon, pear, orange) are at column b and the number of fruits are at column c.
So it looks something like this below.
I know pivot table does the trick but is there a way to use code to consolidate this?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The name of fruits (ie apple, lemon, pear, orange) are at column b and the number of fruits are at column c.
So it looks something like this below.
I know pivot table does the trick but is there a way to use code to consolidate this?
Student number | Fruits | Number of Fruits |
3443 | apple | 3 |
3322 | orange | 2 |
3443 | apple | 44 |
5533 | orange | 1 |
3322 | orange | 9 |
5533 | apple | 4 |
3443 | orange | 78 |
5533 | orange | 3 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>