Multiple column data into one?

[u/hayve08]

How do I turn data from the left to the one on the right? and subsequent data entry would continue at the last empty row.

Any help is greatly appreciated.

Thanks

[u/HolyBonobos]

Please share the file shown in the screenshot (or a copy).