Using VBA I need to create a new table and move data from a single column in an existing table to (10) separate fields in the new table.
Existing table: aaa


bbb
ccc
ddd
eee
fff
ggg
hhh
iii
jjj

New table: f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 (Field names)
aaa bbb ccc ddd eee fff ggg hhh iii jjj

How can I do this. TIA