**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.*