Hi
This is my first time on here - I thought i was relatively competent with vlookups pivot tables etc - but does anyone know how to rearrange multiple smaller tables (i think I can try and get rid of blank rows etc) into one large one if the columns are not ordered in the same way - i was thinking of a vlookup and then maybe an IF statement to try and match up the category title? Any help greatly appreciated!! i have put the two before and after examples below:

This is the original data:
Name number Category titles

b2 c3 e5 f6
natalie 123456 20 30 50 60

a1 b2 d4 e5
james 456789 15 25 45 55

Trying to transform above data into this:
a1 b2 c3 d4 e5 f6
123456 20 30 50 60
456789 15 25 45 55