Data Mapping

sample data file is attached
I have following data:

Class Student names
1st a,b,c,d,e,f
2nd g,h,I,j,k
3rd a,s,d,r,t,y,v,g,h,u,I,o,p
4th z,d,r,w


I want my data in form of:

Student names Classes
a 1st,3rd
b 1st
d 1st,3rd,4th
e 1st
f 1st
g 2nd,3rd
h 2nd,3rd
I 2nd,3rd
j 2nd
k 2nd
o 3rd
p 3rd
r 3rd,4th
s 3rd
t 3rd
u 3rd
v 3rd
w 4th
y 3rd
z 4th

Please help

Please Login or Register  to view this content.

How to run this code ?

How to install code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Not working,

Run time Error '13'. Type Mismatch.

could yo please send me excel file with macro ?

Not working,

Run time Error '13'. Type Mismatch.

could yo please send me excel file with macro ?

Upload the file with the code you attached.