Converting a 2-row table into a multi-column table

Is it possibleto convert a 2-row table such as the one below:

Name 1 Name 2 Name 3 Name 4 Name 5 Name 6 Name 7 Name 8 Name 9 Name 10 Name 11 Name 12 Name 13
Group A Group B Group A Group A Group C Group D Group D Group D Group B Group C Group C Group C Group C

to something that would look like this:

Group A Group B Group C Group D
Name 1 Name 2 Name 5 Name 6
Name 3 Name 9 Name 10 Name 7
Name 4 Name 11 Name 8
Name 12
Name 13

Thanks.