# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, How to make one column with long llist of names into three columns
Solved by A. B. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/10/2018 - 08:42
Hello
Excelchat Expert 07/10/2018 - 08:42
Welcome to Got It Pro
Excelchat Expert 07/10/2018 - 08:44
So, you need to get three columns out of one column?
Excelchat Expert 07/10/2018 - 08:44
User 07/10/2018 - 08:46
I type a list of names on one column and want to make it into three columns
Excelchat Expert 07/10/2018 - 08:46
Okay
Excelchat Expert 07/10/2018 - 08:47
It would be very helpful if you could provide me with an example
Excelchat Expert 07/10/2018 - 08:47
You have a list of names with how many rows?
User 07/10/2018 - 08:48
380i
Excelchat Expert 07/10/2018 - 08:48
And you want to get three columns with how many rows?
User 07/10/2018 - 08:48
100
User 07/10/2018 - 08:49
hello
Excelchat Expert 07/10/2018 - 08:49
Yes, I am here
Excelchat Expert 07/10/2018 - 08:50
I would suggest using very simple formula
Excelchat Expert 07/10/2018 - 08:50
So, if you have your list in column A
Excelchat Expert 07/10/2018 - 08:51
Then you type in cells B1, C1, D1 these formulas
Excelchat Expert 07/10/2018 - 08:51
in B1 you type =A1
Excelchat Expert 07/10/2018 - 08:51
in C1 you type =A101
Excelchat Expert 07/10/2018 - 08:51
In D1 you type =A201
Excelchat Expert 07/10/2018 - 08:51
Then you select all three columns
Excelchat Expert 07/10/2018 - 08:52
I mean all three cells - B1, C1, D1
Excelchat Expert 07/10/2018 - 08:52
Click on the right bottom corner and pull down to row 100
Excelchat Expert 07/10/2018 - 08:53
Let me try to show you what I mean in your file
User 07/10/2018 - 08:53
ok can you show me how to do it on right screen
Excelchat Expert 07/10/2018 - 08:53
I will go with numbers
Excelchat Expert 07/10/2018 - 08:54
Do you follow what I do?
User 07/10/2018 - 08:54
yes
Excelchat Expert 07/10/2018 - 08:55
There you go, you have three columns with values from first column
Excelchat Expert 07/10/2018 - 08:55
Is that something what you were looking for?
User 07/10/2018 - 08:55
yes will the names appear on three columns
Excelchat Expert 07/10/2018 - 08:56
Yes, any value that is in first column will appear in three columns
Excelchat Expert 07/10/2018 - 08:57
Do you want to test it and let me know?
User 07/10/2018 - 08:58
when I type on column B1 A1 and then C1 as A101 and D1 as A201 andthen what
Excelchat Expert 07/10/2018 - 08:58
You select all three cells
User 07/10/2018 - 08:58
press what
Excelchat Expert 07/10/2018 - 08:59
Just mark with mouse
User 07/10/2018 - 08:59
u mean click with the mouse
Excelchat Expert 07/10/2018 - 08:59
Or select B1 and while holding Shift button, press right arrow two times
Excelchat Expert 07/10/2018 - 09:00
Yes, click with the mouse on B1 and while holding the click, mark other two cells
Excelchat Expert 07/10/2018 - 09:00
Here, look how I do it
Excelchat Expert 07/10/2018 - 09:00
Understand?
User 07/10/2018 - 09:01
yes sho me thanks
Excelchat Expert 07/10/2018 - 09:01
Ok, look again
Excelchat Expert 07/10/2018 - 09:01
Understand now?
Excelchat Expert 07/10/2018 - 09:02
Time will extend now for another 20 minutes
User 07/10/2018 - 09:02
Excelchat Expert 07/10/2018 - 09:02
Ok
Excelchat Expert 07/10/2018 - 09:02
So, look how I select all three cells
Excelchat Expert 07/10/2018 - 09:03
So, I select cell B1 and while holding click on my mouse, I go to cell D1
Excelchat Expert 07/10/2018 - 09:03
And then I click on right bottom corner of D1
Excelchat Expert 07/10/2018 - 09:04
And pull it down
Excelchat Expert 07/10/2018 - 09:04
All the way to row 100
Excelchat Expert 07/10/2018 - 09:05
I hope you understood my explanation
Excelchat Expert 07/10/2018 - 09:07
If you have any other questions regarding this issue, I am still here to answer
Excelchat Expert 07/10/2018 - 09:13
I assume it's all clear now
Excelchat Expert 07/10/2018 - 09:13
So I will press DONE button
Excelchat Expert 07/10/2018 - 09:13
Thank you for using Got It Pro
Excelchat Expert 07/10/2018 - 09:14
I will be happy to help you again with new question you have
Excelchat Expert 07/10/2018 - 09:14
I am glad I could help
Excelchat Expert 07/10/2018 - 09:14
Have a great day!
Excelchat Expert 07/10/2018 - 09:14
Bye

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.