I cant follow what you are trying to do.

Post a sample dataset/workbook with a proper example indicative of what you are doing and then a proposed layout of what you want as an end result, and you will be more likely to receive help.