How to Map fields combined by comma separator

[Anonymous]

Hi,

I have the following data in Table 1,Table 2 in excel sheet,

Table 1:

EmployeeID	SkillID	Rating
9	1,2,3	Intermediate
8	2,5,1	Expert
10	1,4,3	Basic

Table 2:

SkillID	SkillName
1	C#
2	AngularJS
3	HTML5
4	JQuery
5	QlikView

From the above two tables we want to map SkillID from Table1 with SkillName in Table2. But the problem is, in Table1 SkillID is combined by 3 fields.

For e.g. EmpoyeeID 9 knows three Skills(C#,AngularJS,HTML5) but all those are combined in same column. So we need to seperate the commas and map them with Table 2 SkillName or is there any way to map without removing those commas with SkillName field?

Regards,

Vijay.M

[Anonymous]

ok sorry for the mistake i will change it

[sunny_talwar]

No mistake brother... this is just to keep the community a place where it is easier to find what you are looking for . If you keep on adding new requirements to existing threads, others will have no idea of a new topic being discussed and the new requirement will be hidden from other users looking for same sort of thing. Think of not just yourself, but others who might benefit from your question