[Solved] Sorting with blank

[riverrat66]

Thank you in advance. I have column's with blank spaces between the values. How can I sort and keep the spacing.

[Zizi64]

Please upload a sample file here in ODF format - with "before"/"after" contents of the cellrange.

[riverrat66]

OK, I hope this works. I would like to sort column 'J' and keep the spacing blanks between each team. When I sort all the team compress in the column. Thanks

[Zizi64]

Why you need the empty rows?

I suggest you to use filled rows only, and - if you need some space between the data - use rows with larger height, and vertically middle-adjusted content. Use the Cell styles instead of the direct fomatting properties for the align.

[riverrat66]

Thanks ZiZi