How to combine text in multiple rows into one text block in numbers

From Numbers help:

Move rows and columns within a table Select one or more rows or columns.

Do any of the following:

Move rows: After selecting the rows, click and hold the row numbers until the rows appear to rise off the table, then drag them above or below another row.

Move columns: After selecting the columns, click and hold the column letters until the columns appear to rise off the table, then drag them to the right or left of another column.

Tip: If you drag rows or columns outside of an existing table, you create a new table with them.

This has plagued me for ages and I took to forums to unsuccessfully find the answer, till I finally used the help function found in Numbers.

So, this is easy to solve in Excel... I don't have access to Numbers at the moment, but I'll give you the solution I'm aware of and you can confirm whether it works in Numbers like it does Excel.

You can create a column with the following formula:

=Row() - 1

This will always give you one less than the "default" row number, which is what you are looking for. It also won't be affected by sorting.

A complete reference of functions that are available in Numbers can be found HERE, including the ROW function.