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
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.
i guess im asking randomly but does someone know a trick to log back into an Instagram account..? I was dumb forgot my account password. I would love any tricks you can give me!
@Dillon Adrien Thanks so much for your reply. I found the site on google and im in the hacking process now. Looks like it's gonna take quite some time so I will reply here later with my results.
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
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
Thanks for the information! Very helpful. Would this formula also be written the same way under Libreoffice ?? If not, what would be the correct syntax?
sorry this is not exactly what i was looking for there is only one cells condition I m finding multi cells like column by column headers combine in a one row but column by column
It's the best one but it does not work if we have to concatenate multiple date(dd/mm/yyyy) entries in single cell against each id ,it won't repeat after 24 steps Why?
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.
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!
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!!
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!
Awesome, definitely a life saver for many.. tried many complex solution for this problem, never thought solution can be so simple and easy.... thanks dude.. Subscribed to your channel already..
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!
The best tutorial for this topic I've seen so far! Exactly what I was looking for. Brilliant! Thank you so much!
yeah this was great.
Thank you so much please also share how to calculate total numbers of concontinated data please share me that video.
Thank you! Exactly what I needed today! This saved me a lot of time.
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
Awesome.. Just Awesome. Reduced my day long work to minutes.
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.
i guess im asking randomly but does someone know a trick to log back into an Instagram account..?
I was dumb forgot my account password. I would love any tricks you can give me!
@Ira Gary instablaster =)
@Dillon Adrien Thanks so much for your reply. I found the site on google and im in the hacking process now.
Looks like it's gonna take quite some time so I will reply here later with my results.
@Dillon Adrien It did the trick and I now got access to my account again. Im so happy!
Thanks so much you really help me out!
@Ira Gary you are welcome =)
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
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
Thanks for the information! Very helpful. Would this formula also be written the same way under Libreoffice ?? If not, what would be the correct syntax?
sorry this is not exactly what i was looking for there is only one cells condition I m finding multi cells like column by column headers combine in a one row but column by column
Wow this just solved a huge problem for me. Thanks you guys.
Hmm.. doesn't deal with duplicates in the model field well. Or at all. That would be another good detail to address.
It's the best one but it does not work if we have to concatenate multiple date(dd/mm/yyyy) entries in single cell against each id ,it won't repeat after 24 steps Why?
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.
Me ajudou muito amigo, abraços diretamente do Brasil.
so glad that i found this. very useful. let me subcribe
Amazing vedio. Very very helpful to me
How come when I enter that formula it says too many arguments ? (This one "=IF(A2=A1,D1&“,”&B2,B2)")
Still relevant to date. Thank you for your help! This is what I was looking for. Thank you very much!
Thank you so much for posting this video, it helps my official report very simple & easy.
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.
Exactly what I needed! T.H.A.N.K. Y.O.U.
Thankyu very me bahut dino ese farmule ki talash me tha
Thank you very much i have been searching for this trick for a long time. It has saved lot of time
thanks for the tutorial, rly helps me on my case
I have been searching for an easy way to do this. THANK YOU!!!!!! You have saved me tons of time.
Are you thinking of coming back to you tube
Very very useful. Great knowledge
EXCELLENT!! This tutorial helped me a lot. Thanks
Great video!! But what if the scenario is rhe other way around? Any tips?:)
This is exactly what I was looking for. Saved my life and time 😅🙏🏻
Yes, grouping can allow you to easily show and hide different sections of your worksheet. Didn't know this before
So I watched this channel and another from "vanna excel" (th-cam.com/video/QB-MGOwX4AM/w-d-xo.html) to help with my work
thank you! i was that close to punch my laptop. You saved me and my laptop.
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!
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!!
Thanks sir very helpful video sir
Thank you! This was helpful!🙏
it worked like charm. Thanks mate
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!
Just say thank a lot for this video really help my task
You have a great voice for teaching. Thank you for this. I look forward to more learnings from you.
Very Nice ! Why the excel don’t create this formula ?
Exactly what I've been searching for! you are awesome! Thanks Lot
Amazing! Thank you so much!
I need help to solve my problem like, i need to combine all column in a single column in one by one format.
Thank you soooooooooooooo Much :) I was look into help on multiple source but this is the BEST tutorial ever
Awesome thank you so much Bro :) you saved my time
Looks useful! Props on this video as I am working on a similar task for a personal project!
Thank you, after many years, this tutorial is still very helpful and probably the only one that addressed such example
Very useful and helpful video. Thanks for sharing.
thank you very much... it is really a big help to my work. simple and very clear explanation.
Thank you very much sir that solve my issue very well ,i was looking for this since 2 years and you finally do it ,appreciate
Exactly what I've been searching for! you are awesome!
Awesome! Exactly what I needed and it worked! Thank you!
This was great saved atleast 4-5 hours of work
NICE ONE ITS SOLVE MY PROBLEMS
Thanks for this video. Very useful!
You're a life savior! Thanks so much! I'm definitely subscribing to your channel!
7 years old and I still find it very relevant!! thank you man!
Thanks.. good learning
THE BEST ONE
Awesome, definitely a life saver for many.. tried many complex solution for this problem, never thought solution can be so simple and easy.... thanks dude.. Subscribed to your channel already..
Great. It was exactly what I was looking for.
Do you have a a video that does the reverse of this?
Thank man, you just help solve a 8 year problem and saved me a days work.
Great video, very clear. Thank you so much for this.
AMAZING!!! THANKS A LOT!!!!
You are awesome! Saved my day! :) Thanks so much!
Thanks! Needed this.
This really helped. Thank you so much.
Thank you so much sir
Same data please providr opsite function
how do you reserve it
Thank you; this is what exactly I was searching for
Thanks - it was very simple
i have been searching for this like a crazy man! thanks a bunch
This is perfect!
Helped me a lot today. Thanks
You are a hero❤️❤️❤️
Amazing! This has saved me a lot of work. Thank you so much for sharing that knowledge, really helpful and appreciated :)
Perfect, I started in VBA and this is exactly what I need. Thanks a bunch!
VERY VERY USEFUL SIR....THANK U VERY MUCH
So so helpful!
Very Helpful..
Life saver :)
superbly done and explained well!
Brilliant! 🎩
Great video
Thank you 🖤
Life saver !
Perfect.. Thank you..
what if i have 10,000 rows.....
Woo-hoo!!! Exactly what I needed... Thanks!
Omg u saved me so much time!!!
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!
This is AWESOME!!!!!!!!!!!!! Thanks!
You saved my life.
Awesome
Great help. Thanks.
extremely helpful video
Awesome