Excel sorting - data on alternating rows

[Guest]

I have worksheets with data in several columns, but row entries alternate
[everyother row]. when I sort, the data is in correct sequence but appears
on every row. The blank rows are eliminated. How do I keep the data in the
original form after the sort - every other or every 3rd row? Thanks!

 

[Michael Solomon \(MS-MVP\)]

Please take this question to an Excel newsgroup.

--
In memory of our dear friend, MVP Alex Nichol.

Michael Solomon MS-MVP
Windows Shell/User
https://mvp.support.microsoft.com/communities/mvp.aspx
Backup is a PC User's Best Friend
DTS-L.Org: http://www.dts-l.org/