I'd suggest posting a sample workbook showing the "before" and "after" with the "after" results entered manually. I'd also suggest in the future you make all requirements known up front, as technically your initial question has been resolved.

Thanks.