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
|
No comments:
Post a Comment