Dave O wrote:

Minor change: with column A as your helper the formula would look like
=B2&C2&D2&E2&F2&G2

This works fine if all columns (B to G) contain text data. Columns
containing numbers and dates might not order correctly though.

A quick method is to use the sort button on the toolbar (ascending or
descending):

Start with a cell in the column you want to sort last, then click sort
and repeat for the other columns back to the one you want to sort first.