Let's say that I have an Excel spreadsheet that contains a long list in column A. How might I go about taking every 40 items in column A and moving it to its own column?
For example, A1:A40 remains in column A; A41:80 gets moved to column B and so on.
I'm not looking for a thought process but rather code samples, if available.
Discuss This Question: