How to Combine (Concatenate) Data from Multiple Rows into One Cell in Excel

A full, step-by-step version of this tutorial is available at Excel Tactics here:

[emilyhuang]

The best tutorial for this topic I've seen so far! Exactly what I was looking for. Brilliant! Thank you so much!

[gopikrishna]

It's very professional and nice... My simple way to combine required rows data is as follows... Place filter on top of column(or sort the data)... If it's numeric apply"sum"function and press F2.. It will expand formula select range(i.e, A1:A40.. like that) press"F9"... You will get all numbers, just remove"=sum & brackets"press enter... If you want comma's instead of punctuation symbol... Use replace function..(if it's alphabetical use =concatenate (transpose A1:A40))... Rest is same

[RupaliMulge]

Dude do you even know what you you did? You are saving lives I'm telling you!! Saved me two weeks of work for a humongous datasheet I'm working on and now allowed to download power query. You rock!!

[andreapenna]

Nice one, thanks :-)
Just a tip from my side: when you want to propagate the formula down till the last cell and you have a column on the left without empty cell, it is enough to double click on the little square corner on the bottom right of the cell where you have the formula.

[mazyoonnetwork]

Thank you, after many years, this tutorial is still very helpful and probably the only one that addressed such example

[gabrielr]

7 years old and I still find it very relevant!! thank you man!

[SoulSail]

Finally was able to combine rows as I wanted, doing basically the same thing, but with Item/Product #'s & Prod. Dept. Codes, though the shortcut you suggest to select all rows didn't work

[AmarNath-emfh]

I was dying for past 1 year doing many steps, now you made my work easy like blink. Thanks a lot🙏🙏. I am ready to pay for this formula.

[tmhouckable]

Thank you! Exactly what I needed today! This saved me a lot of time.

[kirinde]

Just wanted to thank you because this is continuing to help people in 2021 as well. Although I am not sure whether there is an alternative way to do this :D Love what you did here

[duhadiana]

Thank you so much I was working with a huge number of data and the Vlook up will only pull the first value. This formula helped me combine the text and then Vlook it up back as a LONG Combined text . Thank you please keep making more videos!

[ankurchauhan]

Awesome.. Just Awesome. Reduced my day long work to minutes.

[trishbrudz]

I have been searching for an easy way to do this. THANK You have saved me tons of time.

[cflucas]

You have a great voice for teaching. Thank you for this. I look forward to more learnings from you.

[yagmurkolsuz]

This is exactly what I was looking for. Saved my life and time 😅🙏🏻

[hrvad]

Simple, easy to understand and nevertheless clever. It's not 100 percent what I was looking for, but I think it was what I needed. Now to figure out how to pick values from multiple columns, slap them together and when the time comes expand the comma list with text into columns. Thanks!

[gaywaysltd]

There isn't any video like yours. Definitely now on I'm your followers. I have clicked on Liked Video and Subscribed. Only one suggestion is that the voice is not loud. Thank you very much.

[westbeverley]

Thank you for sharing! It has been a while since I was in school, and may or may not have learned this (embarrassed to admit!) In less than 4 minutes, this worked for me. Appreciate it!

[ytsirjeff]

Thank man, you just help solve a 8 year problem and saved me a days work.

[afroz]

This was great saved atleast 4-5 hours of work