I would recommend split the table into two tables and joining them on ID. One table, I've called People and the other I've call InfoSource. I've also done a mapping to convert the numeric representation of gender to words.
Below is the script I used and I've also attached the data and QVF.
Please make this response and helpful or correct if applicable to help out other member when search for answers.
(ooxml, embedded labels, table is Sheet1);
//Map Sex from numbers to Man or Woman
Mapping Load * inline [
ApplyMap ('SexMap',Sex) as Gender
CrossTable([Information Source], Data, 1)
Drop table TempData1;
Where Data = 1;
Drop table TempData2;