indicock
New member
- Joined
- Jul 17, 2018
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- excel 2016
Dear Sir,
Good Morning. I need help from you people to do the followingarrangement in excel. There are two sets of data in the same sheet. First Setis column A only. Second set is column C to I. Now the second set of data needto be sorted/arranged like column A (column A and column D should match).Output expected is also given. Kindly help. Thanks for your efforts.
Kindly Help.
Thanks
Good Morning. I need help from you people to do the followingarrangement in excel. There are two sets of data in the same sheet. First Setis column A only. Second set is column C to I. Now the second set of data needto be sorted/arranged like column A (column A and column D should match).Output expected is also given. Kindly help. Thanks for your efforts.
A | B | C | D | E | F | G | H | I |
10MAT31 | C1 | 10CSL37 | 69 | 56 | 67 | 45 | 82 | |
10CS32 | C1 | 10MAT41 | 78 | 60 | 41 | 45 | 36 | |
10CS33 | D2 | 10CS35 | 65 | 66 | 60 | 49 | 82 | |
10CS34 | C1 | 10CSL38 | 72 | 80 | 72 | 58 | 81 | |
10CS35 | D3 | 10CS34 | 40 | 12 | 25 | 20 | 47 | |
10CS36 | E1 | 10CS36 | 45 | 46 | 40 | 40 | 47 | |
10CSL37 | C1 | 10CS32 | 44 | 40 | 46 | 36 | 47 | |
10CSL38 | C1 | 10MAT31 | 47 | 51 | 41 | 44 | 51 | |
10MAT41 | F1 | 10CS33 | 48 | 43 | 26 | 27 | 48 |
EXPECTED OUTPUT | ||||||||
A | B | C | D | E | F | G | H | I |
10MAT31 | C1 | 10MAT31 | 47 | 51 | 41 | 44 | 51 | |
10CS32 | C1 | 10CS32 | 44 | 40 | 46 | 36 | 47 | |
10CS33 | F1 | 10CS33 | 48 | 43 | 26 | 27 | 48 | |
10CS34 | D3 | 10CS34 | 40 | 12 | 25 | 20 | 47 | |
10CS35 | D2 | 10CS35 | 65 | 66 | 60 | 49 | 82 | |
10CS36 | E1 | 10CS36 | 45 | 46 | 40 | 40 | 47 | |
10CSL37 | C1 | 10CSL37 | 69 | 56 | 67 | 45 | 82 | |
10CSL38 | C1 | 10CSL38 | 72 | 80 | 72 | 58 | 81 | |
10MAT41 | C1 | 10MAT41 | 78 | 60 | 41 | 45 | 36 |
Kindly Help.
Thanks