为每个具有来自多个列的数据的单元格创建一行

I'm dealing with data that has been generated from a survey that has a unique respondant ID as the first column and then has multiple columns relating to the choices of country that the respondent was looking at in relation to finding employees. So my table looks something like:I'm dealing with data that has been generated f