How to merge two columns in Excel without losing data

Поділитися
Вставка
  • Опубліковано 13 жов 2024

КОМЕНТАРІ • 195

  • @lungimarch6060
    @lungimarch6060 Місяць тому +3

    This was short and straight to the point, and extremely helpful! Thank you

  • @joshuaforrest1143
    @joshuaforrest1143 Рік тому +7

    Man you have no idea how much you just helped me and saved me so much time. Thank you!

  • @straightouttabavington4090
    @straightouttabavington4090 2 роки тому +27

    You are the man! Exactly what I needed in less than a minute and way easier than I expected! Thanks a millie :)

  • @ekiamediambedeka5188
    @ekiamediambedeka5188 3 роки тому +34

    I would say that this is how to merge data but how does one exactly merges two columns together?

  • @mecheloumojana
    @mecheloumojana 2 дні тому

    Thank you! This actually works. It saved me a lot of time!

  • @bryancastilleja839
    @bryancastilleja839 2 роки тому +5

    Thank You , super easy to follow, even more so showing the why you don't delete prior to copying the record. you are the man!!

  • @danvee3928
    @danvee3928 3 роки тому +2

    Awesome job. I had to watch 3 other videos to get yours. A total winner!!!!

  • @franks.6134
    @franks.6134 Місяць тому

    Never knew, and extremely grateful for this. I needed it.

  • @ShaneKearney321
    @ShaneKearney321 3 роки тому +7

    Genius! Thank you so much. This saved a huge amount of time and copying and pasting!

  • @odettedegrandis5794
    @odettedegrandis5794 4 роки тому +7

    Amazing, thank you for sharing your knowledge! I fixed my file within 1 minute only with your help!!!

  • @funmilayoarikawe9945
    @funmilayoarikawe9945 2 роки тому +1

    Thank you. You just saved me 4 days work.

  • @pranitbhise1574
    @pranitbhise1574 3 місяці тому

    Thank you so much for this tutorial...It helped me to merge data of 235 rows in a minute

  • @e4300
    @e4300 3 роки тому

    Dear Sir , I want to Thank You; and Big. Straight to the point and NO music. This was a lot of help to me.

  • @IsomeV
    @IsomeV 11 місяців тому

    Absolutely saved me so much time!! Thank you :)

  • @amitabhshukla5950
    @amitabhshukla5950 9 місяців тому

    Absolutely wonderful. That's exactly what I needed!!

  • @oddanneout
    @oddanneout Рік тому

    I LOVE YOU!!!! Thank you for fixing my problem 🔥❤️❤️❤️👌🏼🤣😉

  • @ruthandcolors
    @ruthandcolors Рік тому +2

    Thank you so much! I just used it now.

  • @kanurilakshmanakumar1783
    @kanurilakshmanakumar1783 3 роки тому

    Thank for posting this video my file had completed as fast as possible thanks for ur help

  • @katrinajones9823
    @katrinajones9823 4 роки тому +12

    Spot on. Just what I needed. Thank you!

  • @shaylamillman5574
    @shaylamillman5574 Рік тому

    Thank you bro I needed this today.

  • @razerfish
    @razerfish Рік тому

    Thanks for a quick lesson. Helped tremendously.

  • @akiiparks
    @akiiparks 7 місяців тому

    Excellent video and thank you for sharing

  • @sathyarao8795
    @sathyarao8795 Рік тому

    Thanks i was figuring long for the solution

  • @shivanshsharma6381
    @shivanshsharma6381 2 роки тому

    Thanks ...This saved a lot of time....

  • @yusufylmz24
    @yusufylmz24 5 місяців тому

    Hello.. I did it and it work thank you but i was need that for another issue which is i need to copy the cells which combined but it actually shows me the formula not the name :( so is there any formula that we can copy the cells ? thank you

  • @Bunlizlaw
    @Bunlizlaw 2 місяці тому

    Very helpful, thanks so much

  • @afnansahi-sg7sb
    @afnansahi-sg7sb 4 місяці тому

    Seiously Thank you Sir
    Bundle of thanks my dear brother

  • @Aimable789
    @Aimable789 5 місяців тому

    Thank you soo much my brother, it helps me so much

  • @rggamitgamit9299
    @rggamitgamit9299 2 роки тому

    Thank u so much at last minut i have to present my sheet perfectly. Thank u again🤗

  • @Aman1818
    @Aman1818 2 роки тому

    Thanks for a quick video.

  • @mohaunkosi1208
    @mohaunkosi1208 3 роки тому +2

    exactly what i needed, thank you so much man.

  • @leahmillendez
    @leahmillendez 2 місяці тому

    thank you for this, God bless

  • @llevani1
    @llevani1 Рік тому

    Life saver tutorial. Thank you

  • @kellya8425
    @kellya8425 Рік тому

    Great vid. Can you make a vid that shows how to fill a column but only the blank cells with another column data? So if the 1st column has data , then do not fill w/the other columns data

  • @michaeldesaussure2770
    @michaeldesaussure2770 2 роки тому

    Thank you so much for this have a great day.

  • @bellaflora1232
    @bellaflora1232 10 місяців тому

    Thank you so much this was helpful

  • @aabracadabra8888
    @aabracadabra8888 7 місяців тому

    Thank you sir! Precious info!

  • @shahidbukhari9952
    @shahidbukhari9952 11 місяців тому

    Thank you - helped me.

  • @ujjolmarak1428
    @ujjolmarak1428 2 роки тому

    Ohhh... Salute boss... I was fighting with this issue

  • @a-z748
    @a-z748 3 роки тому +1

    THANK YOU SO MUCH YOU SAVE MY TIME MAY GOD BLESS YOU

    • @manasdas9461
      @manasdas9461 3 роки тому

      What if I don't want space then?

  • @moneyonaction-manojgupta3880
    @moneyonaction-manojgupta3880 2 роки тому

    Easy but Most Important which is done in a minute.......appreciate you a lot.....it helped me lot.....keep it up. I proudly subscribed your channel.👌

  • @cayad2591
    @cayad2591 3 роки тому

    I love you!! saved me hours of doing it the wrong way!! 💕👍

  • @kirangosavi5907
    @kirangosavi5907 Рік тому

    Thanks for sharing valuable info.

  • @oscarbchacon
    @oscarbchacon Рік тому

    You. Are. The. Man... My man...

  • @dpheazmiriganj8343
    @dpheazmiriganj8343 3 роки тому

    Thanks. I solved my problem within this tips

  • @skrasel6375
    @skrasel6375 2 роки тому

    Excellent job

  • @shreepreethi9436
    @shreepreethi9436 3 роки тому +1

    Brilliant.you saved my time. Thank you.

  • @clkirk70
    @clkirk70 2 роки тому

    so simple and quick... thanks...

  • @MuhammadIsmail-bi7fg
    @MuhammadIsmail-bi7fg 2 роки тому

    Exactly what i was looking for

  • @rhushikeshtarkar8811
    @rhushikeshtarkar8811 2 роки тому

    Thank you sir for this information🙏

  • @beheshtapaiman700
    @beheshtapaiman700 3 роки тому

    God bless you Sir. 💐💐💐😍

  • @eduard348
    @eduard348 Рік тому

    Thank you Excel wizard.

  • @ajpierre
    @ajpierre 2 роки тому

    This was very helpful

  • @waliinentertainment
    @waliinentertainment 3 роки тому

    thanks bab from ethiopia

  • @chillier8363
    @chillier8363 9 місяців тому

    one of my column has strike through in the text the other does not. is there a way to combine both but keep the strikethrough from the one column?

  • @abrarhussain8719
    @abrarhussain8719 2 роки тому

    such a great job! Genius

  • @youtubetutorial4916
    @youtubetutorial4916 4 роки тому

    Really thanks verymuch ... This what i expected...

  • @Nekota_
    @Nekota_ Рік тому

    This is so helpful, thank you!

  • @TheFunProphet
    @TheFunProphet 2 роки тому

    I love you random stranger!

  • @savitrisavitri4090
    @savitrisavitri4090 Рік тому

    thank you bro appreciate i could able to do it

  • @shabrotherss
    @shabrotherss 6 місяців тому

    Thank you for your help

  • @zehlenmath
    @zehlenmath 2 роки тому

    Sir i want a help from you. I have 2 exal file. In 1st file a have 8000 name and some other detail. And in second file I have name and emails of 1500 people. Who already in 8000 people. Now I just want to make a exal file of these 1500 with email id. And other detail (detail in 1 file ) how can i do this.

  • @stella8900
    @stella8900 3 роки тому +1

    I love the tutorial.. thank you

  • @ThePannGoogolConsultants
    @ThePannGoogolConsultants 2 роки тому

    Exactly what i needed. thanks

  • @BrendonButler
    @BrendonButler Рік тому

    Very helpful, thank you!

  • @lionelperez659
    @lionelperez659 29 днів тому

    how about if i want to return to original column?

  • @TorranceHart
    @TorranceHart 3 роки тому +1

    Thank you! So helpful!

  • @anubhavsahni
    @anubhavsahni 2 роки тому

    Excellent.. Thanks so much.. :)

  • @jamesgoode249
    @jamesgoode249 Рік тому

    You da real MVP

  • @waliinentertainment
    @waliinentertainment 3 роки тому

    exactly what i need thank u for support me dud

  • @younger2466
    @younger2466 5 місяців тому

    Thank you very much!

  • @arishaaemon4004
    @arishaaemon4004 3 роки тому

    Great Info. Can you please tell me the procedure of separating full name in first name and last name respectively?

    • @Nova_Devi
      @Nova_Devi 3 роки тому

      Data tab at top
      Then "text to columns" under data tools

  • @hmjcouple1238
    @hmjcouple1238 Рік тому

    Wow.
    Great!
    Sir,

  • @samfenn7206
    @samfenn7206 3 роки тому

    Brilliant, exactley what i wanted and saved me lots of time, Thanks :)

  • @kalpeshg1100
    @kalpeshg1100 Рік тому

    Thank You So much 🥰

  • @amoinKhan79
    @amoinKhan79 Рік тому

    WOW you solve my 500 Name in Sheets for Certificate Genius MAN.......

  • @latebloomermusic
    @latebloomermusic 11 місяців тому

    BOSS! I LOVE YOU!

  • @PawnerSawyer
    @PawnerSawyer 11 місяців тому

    thanks bro God bless

  • @RajuBhai-ww1fy
    @RajuBhai-ww1fy 2 місяці тому

    Awesome
    That's which I need..

  • @divyajayachandran2199
    @divyajayachandran2199 3 місяці тому

    Thank you so much bro

  • @sairambokil7299
    @sairambokil7299 3 роки тому

    Hi sir,
    I have some data in different boxes.
    Ex
    1A have some name - car v
    2A have some kilometers - 5000
    3A have some time in time format like - 12:12:10
    4A I used &" "& this formula sad merge all 1A, 2A, 3A so it show - car v 5000 4.000 so all data merge but time did not come properly due to time format how I can love this.
    I need merge all data

  • @avijitdey7469
    @avijitdey7469 3 роки тому

    Love that. Thanks bro.

  • @YuzimZ
    @YuzimZ Рік тому

    Thanks mate, was about to throw the damn pc out the window xd

  • @raghulrajendran7485
    @raghulrajendran7485 2 роки тому

    Thanks a lot brother

  • @Elsiiiie
    @Elsiiiie 27 днів тому

    thank you, thank you, thank you!!

  • @Ekanshvg
    @Ekanshvg Місяць тому

    Thanks alot Sir

  • @benzamanpaul3887
    @benzamanpaul3887 Рік тому

    Mind-blowing

  • @sanjeevsaikia208
    @sanjeevsaikia208 Рік тому

    Very helpful

  • @arrow9975
    @arrow9975 10 місяців тому

    Thanks man ❤

  • @vibezone9832
    @vibezone9832 3 роки тому

    Learned this. But it comes ok only when I write CONCATENATE and not CONCAT - Thanks from India

  • @rajkumarr9861
    @rajkumarr9861 6 місяців тому

    Thank you Sir

  • @vijaybhatt729
    @vijaybhatt729 4 роки тому

    Thank you sir this helped me a lot

  • @naveenraja1669
    @naveenraja1669 2 роки тому

    Thanks dear

  • @payalhr5593
    @payalhr5593 2 роки тому

    Thank you so much

  • @asimusht3085
    @asimusht3085 2 роки тому

    Thanks Man!!

  • @ripleyhrgiger4669
    @ripleyhrgiger4669 Рік тому

    Thank you! I'm having to deal with a really complex import and it only allows me to import 100 users at a time (4,000+ users) which is really annoying. Well, one field wants keywords for search terms so I needed to concatenate several fields with comma separation so I didn't have to manual type everything. And who the fuck decided to limit user imports to 100 at a time? I've never dealt with just a restriction before!

  • @ketkiponkshe5456
    @ketkiponkshe5456 4 місяці тому

    Thanks a ton!!!!!!!

  • @shaminashaikh4882
    @shaminashaikh4882 4 роки тому +1

    Thank you sir 🙏🏻

  • @rockypiccio4100
    @rockypiccio4100 3 роки тому +1

    This is great, thanks!

  • @marathongirl27
    @marathongirl27 2 роки тому

    This was exactly what I needed! Thank you!