How to make rows with data in Google Sheets through one?

Question

Google Sheets

There is a table with data. you need to make sure that all even lines contain data, and odd ones become empty. Data cannot be deleted. It is necessary to insert empty lines after each line with data. Rows with data of the same length.

Answer 1

I decided myself.
The data is in sheet Sheet2 in each line
. You need to create another sheet. It must be empty.
It is necessary to put down the numbers 1, 2, 3, 4 in the first column, but not in each cell, but through an empty line.
That is, 1 in cell A1, 2 in cell A3, 3 in cell A5, 4 in cell A7.
Then in column B in the cells behind the numbers (B1, B3, B5, B7 ...) the formula must be written
in cell B1 = INDIRECT ("Sheet2! A" & A1) where A1 is a reference to cell A1 containing 1
in cell B3 =INDIRECT("Sheet2!A"&A3) where A3 is a reference to cell A3 containing 2
in cell B5 =INDIRECT("Sheet2!A"&A5) where A5 is a reference to cell A5 containing 3
in cell B7 =INDIRECT ("Sheet2!A"&
Now the data from Sheet2 will be on a new sheet in cells B1, B3, B5, B7,
that is, in one line.