Excel programming - Conditional sorting

[Praveen Mishra]

Dear All,

I am facing a problem which has taken much of my time. I have to set of data
parallel to each other, related, but not in sync I have inserted divider
whenever the data changes, horizontally. But I can see that there are empty
cells in between the divider even if one particular section contains
accurately the same set of data. I canm not delete the empty cells as it
would affect the dividing rows. Could you all please let me know some way
out. I am giving excerpt here:
______________________________________________________
BEST BUY CO. INC. - 86516101 BEST BUY CO. INC. - 86516101
BEST BUY CO. INC. - 86516101
BEST BUY CO. INC. - 86516101

 

[Joel]

The only real solution is to write a macro to remove and add the formating.
Remove the formating, fix the problems, then re-format