Converting excel columns into a table

[kestul2]

Hello,

I have a list of names (about 100 or so) in a single column in excel. These names need to be put into a table format so that they can be printed in a bulletin. Typically it's 3 across and then however many rows needed. The person doing this before me manually copied and pasted all of the names into word and then manually formatted it, but I feel like there has to be an easier way to do this using a formula/function. Basically just trying to convert a single columns worth of data into a table. The only parameter for the table is that it needs to be 3 columns. Eventually this table will be put into word since this is the format that the whole bulletin is in. Any help is greatly appreciated!!

Thank you!
Katie

[Pete_UK]

Do your names start in A1 or A2 (or somewhere else)? Would it be acceptable to show the names in C1, D1 and E1, and then in C2, D2, E2 and so on until the end of the list?

Pete

[Pete_UK]

Ah well, you've probably gone home from work. Assuming your names do start in A1 and you want them in C1 across to E1 and then down, you can put this formula in C1:

=INDEX($A:$A,(MOD((COLUMNS($C:C)-1),3)+1)+INT((ROWS($1:1)-1))*3)

Copy into D1 and E1, and then copy C1:E1 down as far as you need to.

Hope this helps.

Pete

[kestul2]

Pete - forgive me for not responding earlier. This is exactly what I needed. Thank you so much!!

[jeffreybrown]

@kestul2,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save