software

My picture is in 4 rows and I need to display all the rows but only want to
sort by 1 cell w/in the rows and not lose the information in the other cells
that i would like to display together

You need to quot;associatequot; the four rows together. Normally done using a helper
column and concatenating a name and row number, like
=quot;Picture1quot;amp;quot;_quot;amp;quot;Row101quot;
=quot;Picture1quot;amp;quot;_quot;amp;quot;Row102quot;
=quot;Picture1quot;amp;quot;_quot;amp;quot;Row103quot;
=quot;Picture1quot;amp;quot;_quot;amp;quot;Row104quot;

And then doing your sort on this column.....

hth
Vaya con Dios,
Chuck, CABGx3quot;nbCLEquot; wrote:

gt; My picture is in 4 rows and I need to display all the rows but only want to
gt; sort by 1 cell w/in the rows and not lose the information in the other cells
gt; that i would like to display together