Separate string into separate cells

Good day to all,
I worked with an archeic system called Blue Vista and need help. When doing a query the system will produce was you see below but every row is in cell a1 a2 a3. i would like to separate a1 into b1 c1 d1 e1 f1 etc etc....
Anyone have any ideas?