Excel Transformation?

How does one transform some thing in escel in the format ANY, B, D, D; AT THE, F, G, H; J, E, L, M; to something similar to A, B; D, D; AT THE, F; G, H; J, E; L, M; Considering the commas addressing a alter in column and also the semi colons symbolizing a modify in strip.Thanks with the help.

Assume that A for you to M is within A1:M1, put this particular formula from a cell

=INDEX($A$1:$M$1, ROW(A1)*2 +COLUMN(A1)-2)

Copy this down that rows and over the columns, delete dozens of cells together with #REF!
In that case you’re accomplished!

Please contact for much more info.