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
Can you tell me more about your problem?
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
please do it again thanks
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.