Forum Discussion
Every N:N columns to rows
Hi there! I would like to have ever 5th to 8th columns to new rows. See images for better understanding :)
Does anyone has an idea how this could be solved?
I have Office 2013 ...
Hi Marco,
If with formulas you may add
=OFFSET($A$1,MOD(ROW()-1,7),INT((ROW()-1)/7)*4+COLUMN()-1)
into A8, copy it to the right till D8 and when copy down A8:D8 till end of your data.