How to convert uploaded table1 to table2?

Don't bother about the file. it was easy enough to replicate. In (say) J2, copy acrossto L2 and down as far as needed:

=OFFSET(A$10,3*(ROWS($1:1)-1),,,)

In M2, copy down:

=OFFSET($D$11,3*(ROWS($1:1)-1),,,)&" "&OFFSET($D$12,3*(ROWS($1:1)-1),,,)

in N2, copied across to O2 and then down:

=OFFSET(E$10,3*(ROWS($1:1)-1),,,)

All assuming that your data start in A10...