1

Current:

-------------------------------------------------------------------
| Amy | Adam | Bob| Cliff | Dave | David | Derek |...| Zachary
-------------------------------------------------------------------

I have a long row with around 300 names. Is there any formula/method that can split the row into multiple rows? I would like to have 10 entries on every row to make it easier to manage, example:

---------------------------------------------------------------------
| Amy | Adam | Bob| Cliff | Dave | David | Derek | Diana |Elise| Eve |
-------------------------------------------------------------------
| Felix | Fiona | Ford | Gary |... | ... | ... |....|....|Luke|
-------------------------------------------------------------------
|....|.....|.....|.....|.....|......|.....|....|Zachary|
-------------------------------------------------------------------
0

Assuming your row of 300 names starts in cell A1:

Insert this formula into cell A2:
=INDEX($1:$1,INT(COLUMN()+(ROWS(A$2:A2)-1)*10))

Drag the results shown in A2 across to J2.

Drag the resulting row down to row 31.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.