Convert Multiple Columns to Single Row?

**AboveBeyond** · 08-30-2007, 04:47 PM

I"m trying to convert multiple columns to a single row separated by commas.

Example:
Multiple Columns

1.Joe
2.Jack
3.Bill
4.John

To One Row:

Joe,Jack,Bill,John

Thanks for any help!

**oldchippy** · 08-30-2007, 05:47 PM

The way your question is written, I'm not sure whether you want four columns to one row, or four rows to one row?

If you want the later, then if your data is in A1:D1, then

Please Login or Register  to view this content.

If its the former with your data in A1:A4, then you could do this, select B1:D1 and type this

Please Login or Register  to view this content.

,but enter as an array formula with Ctrl+Shift+Enter to apply { }

Then in F1 put the first formula again

**ellibelli** · 08-27-2012, 03:29 PM

I have text in A1:A24 and I want to move it to B1 and have it look like this (TEXT1, TEXT2, TEXT3....). I think this is what the original poster was asking but I can not get it to work for me. Am i asking something different? I am using Excel 2003.
Thanks!

**Cutter** · 08-27-2012, 04:13 PM

Hello ellibelli, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**Cutter** · 08-27-2012, 05:07 PM

Your post does not comply with Rule 6 of our Forum RULES. Common courtesy is the order of the day. Avoid coarse language, provide feedback to suggested solutions, and take the time to thank those who took their time to help you.