I am importing a data file which is a single long column of data in repeating rows of 12 and 1 space. How can I get these into a Table format that I can use in my pivot table? . Eg

Male
25
John
French
left handed

female
23
Louise
English
Left handed

etc

to
Male | 25 | John | French | Lefthanded
Female | 23| Louise | English | Left Handed
Etc

Thanks
Simon