How to Combine Data in 2 Table of different Worksheets?
Sample raw data in worksheet Sheet2:
Excel 2007
| A | B | |
|---|---|---|
| 1 | Identity | Score |
| 2 | 2 | 6 |
| 3 | 3 | 7 |
| 4 | 5 | 8 |
| 5 | 7 | 5 |
| 6 | 9 | 7 |
| 7 | 11 | 4 |
| 8 | 12 | 56 |
| 9 | 15 | 16 |
| 10 | 16 | 12 |
| 11 | 18 | 11 |
| 12 | 20 | 10 |
| 13 | 22 | 9 |
| 14 | 23 | 6 |
| 15 | 26 | 8 |
| 16 | 30 | 12 |
| 17 | 31 | 11 |
| 18 | 33 | 21 |
| 19 | 35 | 24 |
| 20 | 41 | 23 |
| 21 | 43 | 15 |
| 22 | 45 | 12 |
| 23 |
Sheet2
And, in worksheet Sheet1:
Excel 2007
| A | B | C | |
|---|---|---|---|
| 1 | Identity | Name | Score |
| 2 | 1 | Mr. Name 1 | |
| 3 | 2 | Mr. Name 2 | 6 |
| 4 | 3 | Mr. Name 3 | 7 |
| 5 | 4 | Mr. Name 4 | |
| 6 | 5 | Mr. Name 5 | 8 |
| 7 | 6 | Mr. Name 6 | |
| 8 | 7 | Mr. Name 7 | 5 |
| 9 | 8 | Mr. Name 8 | |
| 10 | 9 | Mr. Name 9 | 7 |
| 11 | 10 | Mr. Name 10 | |
| 12 | 11 | Mr. Name 11 | 4 |
| 13 | 12 | Mr. Name 12 | 56 |
| 14 | 13 | Mr. Name 13 | |
| 15 | 14 | Mr. Name 14 | |
| 16 | 15 | Mr. Name 15 | 16 |
| 17 | 16 | Mr. Name 16 | 12 |
| 18 | 17 | Mr. Name 17 | |
| 19 | 18 | Mr. Name 18 | 11 |
| 20 | 19 | Mr. Name 19 | |
| 21 | 20 | Mr. Name 20 | 10 |
Sheet1
Worksheet Formulas
|