Combine or Transpose Text from Multiple Rows

thank you, very helpful

Waste of time to see this video

Thank you so much for this ♥

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

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

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?

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

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!

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?

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

Thank you. Very helpful

Thank you Doug!! You are the best.

Thanks 😊

Very good and helpful. Tks!

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

Lifesaver!!

Thank you So much Sir, you are great.

Just what i needed today. thank you :)

Thank a lot....👍

VERY NICE,

YOU SAVE MY LIFE

You are an absolute hero!

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

Thank you sir

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

Thanks, this helped me a lot!

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

This is super helpful. Thanks a lot!!!

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.

=CONCATENATE(TRANSPOSE(I73:I78)

Obrigado Doug.

Thank you Doug!! You are the best.

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 .

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!

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