joining rows in Excel

  • Thread starter Thread starter sfalcone
  • Start date Start date
S

sfalcone

I'm trying to use two rows to represent each record in an
Excel database list I'm developing.

The challenge comes in with sorting--at which point my
nice neat database will get scrambled as the second row in
each record will not stay with the first.

Is there a way to connect two rows so that they always
stay together as the data list gets sorted in different
ways, or filtered in different ways.

Thanks much,

Sam
 
Hi Sam
I'd strongla suggest to change your spreadsheet layout :-)
Use ONLY one row per record otherwise you'll always get problems with
sorting, filtering, reports, formulas,etc.
 
What Frank has said is 100% corect.

However, until you revise your entire data base, you could try to add
whatever the sort key is, to the other row.

For instance, if column A contains your record I.D., and it's only entered
into every other row of the column, and your first record starts in A3, but
you have other data in A4, you could insert a *new* column B, and try this:

In B3 enter
=A3
In B4 enter
=A3
In B5 enter
=A5
in B6 enter
=A5

Now, simply select these four cells, and drag down to copy as far as needed.
You should now be able to sort using this new column as the sort key, UNTIL
you revise the configuration of your list.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi Sam
I'd strongla suggest to change your spreadsheet layout :-)
Use ONLY one row per record otherwise you'll always get problems with
sorting, filtering, reports, formulas,etc.
 
Back
Top