How to wrap text in multiple cells?

Question

Google Sheets

Tell me please. I need to transfer the texts that I circled in a red square right on the side of the text above, as I showed in the screenshot. Is it possible to do this with some kind of formula so that I don’t do it manually?

Answer 1

Just make equal and a link to the data cell.
Those. for example, you need to transfer from cell A2 to B1. In B1 write "=A2", and stretch down.
But since you have to pull up through the formula and the first line, you just need to clean it up, make a filter on column A, on empty values ​​and remove unnecessary data from column B.

Answer 2

It is assumed that the format is the same everywhere, as in the example: a cell with a quote, directly below it is a cell with the "address" of the quote in the book, then an empty string. The task is to transfer the value of the cell with the "address" to the cell to the right of the quote. Source line with "address" - to delete?
1. Place the cursor in the cell you want to transfer to, in the first line where you want to do this - i.e. to the right of the first raw quote, in your example, to the right of "So Christ..."
2. Write there

=IF(AND(LEN(OFFSET(%адрес_ячейки_с_цитатой%;1;0))>0;LEN(%адрес_ячейки_с_цитатой%)>0);OFFSET(%адрес_ячейки_с_цитатой%;1;0);"")

or, if for some reason you have Excel in Russian,

=ЕСЛИ(И(ДЛСТР(СМЕЩ(%адрес_ячейки_с_цитатой%;1;0))>0;ДЛСТР(%адрес_ячейки_с_цитатой%)>0);СМЕЩ(%адрес_ячейки_с_цитатой%;1;0);"")

-- at the same time, instead of %cell_address_with_quote%, specify the address of the corresponding cell
3. Enter.
4. Return to this cell, copy it.
5. Next, you need to insert it into all the rows of this column that need to be processed - you can completely select a column or range if there is nothing you need.
6. At the output, we get that to the right of the cell with the quote - the cell contains the "address", which is taken from below it. But this is not text, but a link to the original "address".
7. For it to become text, you need
to select all the cells to the right of the quotes, where we now have the formula entered by us (if there are no other formulas in the column that need to be saved,
8. If after that you need to delete the original lines with the "addresses" of quotes that are below them, then the easiest way to do this is with an autofilter - for example, if the table structure is the same as in the example, filter so that
- in the column where there are quotes and address - hide empty lines, AND
- in the column to the right of it, where we copied the values ​​​​- "addresses", hide NON-blank lines
- select all visible lines - only those in which the original "address" of the quote should remain
- delete lines
- remove autofilter
for the future - if you screenshot the example with row/column headers, it's easier to answer.
If there are questions, write.
PS if there is nothing else in the columns, you can decide otherwise:
- copy the column with quotes and "
- insert it on the right, i.e. there will be two identical columns
- in the top row (it is empty) at the column inserted on the right, delete one cell with the rest shifted up
- delete unnecessary lines with autofilters approximately as described at the end of the previous solution - that algorithm needs to be slightly adapted for this option, but there everything is pretty transparent