I have created a list of potential "skill sets" that leadership in my company may want to track. Now I have sent this list out to the leadership for review. The list is set up in the following manner: Skills down the 1st column. Career fields/specialty across the first row. Now I am asking the management to go through and place an x or multiple x's in each row to help align which skill sets will be tracked for which career specialty. I will receive back 20+ lists and I will need to combine them into one list. I want to keep all of the X's
How do I do this, with out manually going through each line and comparing all 20 copies?
Simplified Example of the list that was sent out:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]IT Specialist[/TD]
[TD]IT Engineer
[/TD]
[TD]Computer Scientist
[/TD]
[TD]IT Mission Support
[/TD]
[/TR]
[TR]
[TD]A+
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A++
[/TD]
[TD][/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A#
[/TD]
[TD][/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C+
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
How do I do this, with out manually going through each line and comparing all 20 copies?
Simplified Example of the list that was sent out:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]IT Specialist[/TD]
[TD]IT Engineer
[/TD]
[TD]Computer Scientist
[/TD]
[TD]IT Mission Support
[/TD]
[/TR]
[TR]
[TD]A+
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A++
[/TD]
[TD][/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A#
[/TD]
[TD][/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C+
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]