It would be best to supply a sample workbook, that shows what your original layout is and what your results should be.
When you reply hit the advanced button, then hit the paper-clip to attach a sample workbook.