need help to copy paste the data from multiple columns into single row.

Hi,
Require assistance for following:
The data available is set of rows (for eg. A1: A20) with some blank rows in between.
Like this the data is present in multiple columns. The range of data is A1:HIR20 (5660 columns)

I want to bring the data into single row, like following
A1:A20 (as is)

The next column i.e. B1:B20 should be cut/paste into 2 rows below, which is A52.
Hence the data will get stored as A22:A41

The next column i.e. C1:C20 should be cut/paste into 2 rows below, which is A43.
Hence the data will get stored as A43:A62 and so on.
The sample excel file with desired output is attached for ready reference.
Please advise,

Thanking you,
Regards,
Amol