Sorting on one column without compressing data in following row

[Burdette]

I would like to sort on a colum high to low - each row has data that applies to the row and that data must be kept associated with that row"

Tyr to show here Row 1 data ----------------- summary
data that goes with row 1
date that goes with row 1
Row 2 data ----------------- summary
data that goes with row 2
data that goes with row 2

This continues on for 40 or more rows.

Can I sort on the summary coumln and still keep the data under the approriate row ?
If yes, how do I do this - if I colapse the rows with the sort the data is of no value to me.

 

[cgcamal]

Hi Burdette,

Please show the sample data you have to get a best idea about the data
inside and the key column you want to sort.

Please use the most approximate content in your sample data showing
the desired output either.

Something like:

Excel Workbook
	A	B	C	D	E	F
1	data	-----------------	summary
2	data	that	goes	with	row	1
3	date	that	goes	with	row	1
4	data	-----------------	summary
5	data	that	goes	with	row	2
6	data	that	goes	with	row	2
Sheet1

To show a sample of your table you could use HTML MAKER.


Regards