I can't understand your requirement at all, please can you upload a workbook which shows how your data is arranged and also how you want the data to look after the macor has been run. Then we might be able tohelp.