connecting/linking data in a row

select all data in range ,then if you sort by one column all the others will follow.

Please follow following steps
1.Select all the rows containing data
2.From the menu bar select data>sort
3.In the sort dialog box, select Column Name from the sort by drop down and check ascending radio button to the right
4.Click ok
Now you get data intact in rows when they are sorted by a column


Chris
------