How can I group a bunch of cells together, so I can sort by colum.

[Pleasehelpme]

I have a large spreadsheet with approx. six columns. All but one of the
columns only requires one cell for all of it's information. How can I sort
all of that data while keeping my column with multiple cells attached to the
original row?

 

[Harlan Grove]

I have a large spreadsheet with approx. six columns. All but one of
the columns only requires one cell for all of it's information. How
can I sort all of that data while keeping my column with multiple
cells attached to the original row?

If you mean something like

A B C D E 1
2
3
F G H I J 4
5
6
K L M N O 7
8

you'll need another column. If the records above were in A1:F8, enter the
following formulas.

G1:
=A1&CHAR(255)&B1&CHAR(255)&C1&CHAR(255)&D1&CHAR(255)&E1

G2:
=IF(A2<>"",A2&CHAR(255)&B2&CHAR(255)&C2&CHAR(255)&D2&CHAR(255)&E2,
G1&CHAR(255)&TEXT(ROW(),"000000"))

Fill G2 down as needed. Then sort the whole table including column G on
column G.