OK I've spent ages racking my brains on how to do this:

I get a lot of data in raw text form, where all values are inline such as this

Name
Nickname
Age
Gender
Name
Nickname
Age
Gender
Name
Nickname
Age
Gender
Name
Nickname
Age
Gender
Name
Nickname
Age
Gender
What I want to be able to do, is either find an option, write a function to sort it on a new page, or even make a macro to sort it into a table in a more useful format of:

Name Nickname Age Gender
Name Nickname Age Gender
Name Nickname Age Gender
Name Nickname Age Gender
Name Nickname Age Gender
Name Nickname Age Gender
Name Nickname Age Gender
Name Nickname Age Gender
So that I can then use the data for further work, without having to move it around by hand. This is not too inconvenient for my example, but when you have a few hundred entries and several values for each, it can become rather time-consuming and unproductive, the type of task computers were made to do for us. I know how I would go about doing this as a *nix shell script or in C++, but I would prefer a solution where I can just click a button from within excel.