Summary
How to combine results from two Analysis
Content
Hi All,
I have to combine the results of two analysis into one.
Please find the details of input Analysis A and Analysis B below.
The expected results are also mentioned, can you please guide me?
Please note that the number of "subjects" are fixed.
| Analysis A |
|
|
|
|
|
|
|
| Stud No |
Stud Name |
Address |
Country |
Class |
|
|
|
| 123 |
Jack |
Jack Add |
India |
3 |
|
|
|
| 124 |
Eli |
Eli Add |
USA |
3 |
|
|
|
| 125 |
Mack |
Mack Add |
AUS |
4 |
|
|
|
| |
|
|
|
|
|
|
|
| Analysis B |
|
|
|
|
|
|
|
| Stud No |
Subject |
Mark |
|
|
|
|
|
| 123 |
Match |
60 |
|
|
|
|
|
| 123 |
Science |
70 |
|
|
|
|
|
| 123 |
Social |
80 |
|
|
|
|
|
| 124 |
Science |
99 |
|
|
|
|
|
| 125 |
Match |
30 |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| Output |
|
|
|
|
|
|
|
| Stud No |
Stud Name |
Address |
Country |
Class |
Match |
Science |
Social |
| 123 |
Jack |
Jack Add |
India |
3 |
60 |
70 |
80 |
| 124 |
Eli |
Eli Add |
USA |
3 |
|
99 |
|
| 125 |
Mack |
Mack Add |
AUS |
4 |
30 |
|
|
|
