Combine or Transpose Text from Multiple Rows

Want to transform your list of values into something you can use differently? Like converting multiple rows of values into a single row and concatenate (combine) the values into one comma delimited cell? Learn how to combine cell from multiple rows or columns into one cell without a space, with space or as comma separated values (csv); all without creating any macros.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[jeanettesefers]

This SO saved the day in my world. Thank you for sharing.

[olatunbosundare]

This is a perfect video, I was trying to create a script that would ping multiple IP addresses in a spreadsheet, this helped me a lot, thanks .

[marshalljackson]

Well explained. Great step by step explanation. Thank you for your video.

[rajeshwariroja]

Hello Dough, Its help me a lot. Thank you so much🙂🙂🙂🙂

[toeko]

already used line break function but that line brake in a cell. I want to be each of the cell in a column. How can I do. My required is different things with this video tutorial. This video "turn this" "into this", but I want to do "into this" to "turn this". Thanks

[thedevildiva]

Just what i needed today. thank you :)

[kellypeissner]

Please add transpose to your title. It will make it easier for people that need to transpose their work and for those that don't. Thanks!

[walterkendall]

For the 3rd example if you reverse the formula like so =CONCATENATE(B1, ", ", A2); the list will show in order Item 1 to Item 18

[axia]

Hi
Thanks for short and helpful video
I used your first formula that you showed in video for more than 10 rows of text to 1 cell.writing formula and highlighting it from back till transponse and f9 finally removing curly brackets and enter.now i need to your help that can this formula be applied again and again for different text of rows to one cell(in order to move long lines of text in multiple rows to single cell.)

[ganeshdalvi]

Thank you So much Sir, you are great.

[tanya]

oh my god! you life saver - bless you!!!

[priyat]

Hello Dough, Very Nicely explained. Thank you. I would like to add single quote and comma to each no. like 'Item1', 'item2' . Is it possible using this formula? I tried adding "&" function but results are not as i want.could you please help!

[nitinbhardwaj]

Font colour is getting changed from the original data. How to rectify that?

[dinhvanhung]

This is super helpful. Thanks a lot!!!

[BevenSpangenberg]

how would I accomplish the reserve, my data is separated by commas all in one cell, and I need it separated into one column?

[axia]

HI

CAN YOU FIX IT

IM TRYING TO COPY MANY ROWS WITH TEXT TO  1 CELL BUT THIS ERROR IS COMING. ITS NOT PICKING 1 ROW. I DONT KNOW WHY.

HERE IS THE FORMULA. I hightlighted it till transpose and then pressed  f9 key and removed CURLY brackets with closing with parenthesis and enter.

[tarasherlock]

Hi there, I had a column of 296 item numbers I was using the following function =(Concatenate(Transpose(A1:A296&", "&" ") this is because I wanted a space inserted between the upc's and commas as well, but when I do the F9 function and remove the curly que's I get the following error " You've entered too many arguments for this function. Is there a limit to how many items you can combine with this function?

[citikartshopmagicbuy]

hello acctually i want to do reverce of it i have data in one box seprated by space i want it in cells

[midnitexstar]

Great tutorial. But is there a function where you can do the reverse?
Ie. I have text that is written with commas (Item 1, Item 2, Item 3 etc.) and I want each text between commas to be transposed into separate rows

Is that possible?

[mohamadasyrafhazli]

How to make this works by applying to different row in one cell. Example :-
A
B
C
D
E
F
*not as A, B, C, D, E, F