How to connect rows/cells in Excel?

Hy!
Is it possible to connect multiple excel rows? I need it because when I sort a table in Excel I need some rows to stay together (in the same order).
Would really appreciate some help

Hello Tom333,

Can you better describe what you mean by "connect multiple Excel rows" or post an example?

Thanks,
Leith Ross

Hello Leith!
I made a small example. In the table AAA1 should be connected with row wheres AAA; BBB1 and BBB2 connected to the row wheres BBB etc. Its necessary because when I want to sort by 2. column AAA1, BBB1, BBB2 etc wont be in the correct place. Hope you get what I mean.
Or is there maybe some other ways to create similar table.

Thanks,
Tom

Originally Posted by tom333

Hello Leith!
I made a small example. In the table AAA1 should be connected with row wheres AAA; BBB1 and BBB2 connected to the row wheres BBB etc. Its necessary because when I want to sort by 2. column AAA1, BBB1, BBB2 etc wont be in the correct place. Hope you get what I mean.
Or is there maybe some other ways to create similar table.

Thanks,
Tom

Tom,

I still don't understand what exactly you want. What do you mean by sort by 2 and then "column AAA1, BBB1, BBB2 will not be in correct place "? Which column you are sorting on? Suggest you show a table before a sort and then show the table after sort ( with data in the order you want ) so that I can understand what exactly you want to accomplish. Also mention the column on which you are sorting.

A V Veerkar