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 :)
Thank you in advance!
- Do you still want to keep those columns (from the 5th to the last)
no, as long as they go to the rows :)
Willy Lau wrote:
Do you still want to keep those columns (from the 5th to the last)
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.
