adjusting groups after

[geeky1]

I transposed to be precise 38728 sales values from a table into one column, by using this formula:
=INDEX(MyData,1+INT((ROW(B2)-1)/COLUMNS(MyData)),MOD(ROW(B2)-1+COLUMNS(MyData),COLUMNS(MyData))+1)

Column A consists out of dates, the header is the customers and in the original table the sales values were horizontal, now vertical in one column. I want that the dates and customers shift accordingly automatically. (I hope my explanation is described well)

Anyone?

 

[XLPadawan]

Please upload a workbook and you'll be much more likely to get responses. The ninjas here are super smart, but I haven't found any of them to be mindreaders.

 

[geeky1]

thanks for the advise, attached you will find the document