I have columns ABCD.
A,B and C contain data.
I want D to insert data from A until the value in C hits 4.
After that cell, I want to insert data from B until the value in C hits 5.
After that cell I want to insert data from A again...and so on
Solved by F. A. in 15 mins