You're right: In your first post there is no mention of blank columns to insert, only "Transpose" hinting at it.

That said: I'd need to see a "This is what i have, and this is what it should look like"
because, frankly: I'm struggling imagining the end result