combine multiple cells value in a single cell using comma, space in

how to combine (concatenate) data from multiple rows to one cell.
Combine Multiple Row Value in One Cell
Combine Data From Multiple Cells in Excel
Combine text from two or more cells into one cell
How to Combine (Concatenate) Data from Multiple Rows into one cell
Combine Multiple Row Values in One Cell
How to merge rows in Excel
Combine Multiple Rows into One Cell, Separated by Comma
Merging the Contents of Multiple Cells into One Cell in Excel
Combine Text from Two or More Cells into One Cell
Combine or Transpose Text from Multiple Rows
How to Transform Multiple Row Data into A Single Row

[@user-tf9jx6dq2u]

I second the comment below - didn't understand most of it but this has just made my job a whole lot easier too! Thank you.

[@imdavidlamar]

I've been looking for this for MONTHS!! While I didn't understand a single WORD, this helped. This makes my job SOOOOOOOO MUCH EASIER!!! THANK YOU!!!

[@akshayvibhandik0205]

Yahi dhund raha tha me
Perfect solution mila he
Thank you so much

[@joedas7648]

Bhai thanks.... Really helpful Mera job main bahut kaam aaya 🙏❤️

[@prudhvinerella4201]

Thanks brother, it helps

[@Jaykumar-vj4cy]

Bahut bahut dhanybad sir

[@Trainee..._____07]

ये बढ़िया था गुरु

[@Trainee..._____07]

Bahut bahut dhanyavaad

[@sonamtiwary6338]

Really super information sir

[@ATInstitute]

Thank you... you are a life saver

[@Nowcreates]

Exactly what I needed! Thanks.

[@sumitladhe2375]

Thank you soooooo much bro, no one had told me me like this and u solved my very big problem, i was desperately seeking for this. Thankkkk you so much

[@Russty_copper]

Genius

[@therutujajere252]

Informative ✌✌

[@manojkumarnayak8311]

Thanks for your help

[@manateluguinfo8253]

Very useful sir... Thank you guruji🙏

[@sagarrawat2362]

Thanks buddy 😊

[@Anandmoto]

Thanku very much...It was so useful and to the point 👍

[@chandrasekhardurgaprasadd8878]

Really superb boss
Thank you so much

[@manojgarg7684]

Hey Piyush, gr8 video, very useful, thanks a lot..

[@rakibislam4742]

Thanks a lot...

[@ParaskumarKumar]

So Helpful 👌

[@mugdhanaik7241]

Great video. Thanks a lot. Very helpful

[@PiyushPankajJr]

Thanks for your feedback...🙂

[@motivationsuccess863]

It was very helpful sir, is there any method that to paste it vertical, in this video u shown is done horizontally.

[@financialguru8269]

Horizontally ko ek cell m karna hai. Aur format banakar rakhna jaise entry wo perticular cell m ajaiye

[@ahmadfaraz2962]

Hey mate! Have you heard about "arraytotext" function? Thanks me later

[@vivekvirar]

Thanks for Video. I just have query, if we change the data in main cell it is not transformed to the transposed data

[@PiyushPankajJr]

Use arraytotext function for dynamic changes

[@jidaphaleebalu8366]

It’s is work in formula?in case if I am gonna use sumif function,that’s the data is not in the same row

[@patturoxxxx]

great trick, not many ppl know abt it

[@technicalsolution4911]

Pls iske liye Bhi 1 video banaye sir

[@AG-hc8nz]

Hello I have the case but col b is not fix then how to solve this

[@pankajsaini50]

Thank you sir

[@eradavislinnrealestate2214]

I was desperately seeking something to make this process easier. I am getting the second cell built, but when I pull down, the others aren't populating. Since there is a language barrier for me, it there something you are saying or doing that makes that process work. thanks in advance

[@eradavislinnrealestate2214]

I figured it out.. 😄

[@kamrulislam648]

Great video, helps me a lot, Subscribing you

[@PiyushPankajJr]

Thanks Kamrul:)

[@nischithkumargm3445]

How to paste one cell value to all cells at a time
i.e for example i have put value of E10 to (J12:50) and if the value of E10 changes then automatically value of J12:50 should be also changed
For that please share the formula

[@GIS-Engineer]

Agar isi ka reverse process karna hobto kaise kareinge...single cell aray ko multiple row mai..

[@akshayzalte9274]

Lekin ye to vertical ka horizontal horaha hai,, as it is vertical ka vertical rakhna ho to

[@TheLochan77]

if many cells having two values separated by comma , can thier first value be added through formulae

[@PiyushPankajJr]

Yes you can. Check out the below link;
docs.google.com/spreadsheets/d/1ImOEUE-52jECYwNBjwaB1zOfIcOS7Xji/edit?usp=share_link&ouid=107710792751437620762&rtpof=true&sd=true

[@padmanathang529]

Hi sir.. very informative.. I have a doubt this could be applicable for content list in a single cell using alter enter.. can we combine this type..

[@PiyushPankajJr]

Hi,
Can you please share excel sheet on my email.
Email ID: [e-mail]

[@raviiMaurya]

finally😅😅😅

[@naveedalijamali4414]

Muje aik cel me kitne num aa rahe hen aik cel me total ai wo kese ai ga

[@iram5692]

Agr ak cell ma do amonts likh k jma krni hon

[@polfelipefalgas8290]

Hey Piyush! i need to do the opposite of that in my sheets. Is it possible to put various values in a cell like that 1,2,3,4,5 in different cells?
Thank you!

[@PiyushPankajJr]

Hey Pol..
Yes use text to column function to split no in different cell.
I will share the link 🔗.

[@arjunthammisetty7219]

@@PiyushPankajJr I need link

[@Guptazone]

Mujhe bhi yahi karna hai ,,link kidher h

[@sidkhan9871]

Nice

[@shine777haroon]

Nice informative video thanks
Kiya hm numbers ko text format me kr k justify kr skty hn k ni.

[@PiyushPankajJr]

Kr skte hain..by using VBA

[@karishmathakur3349]

F9 key se formula nahi lag raha . Hp laptop hai kya kare

[@PiyushPankajJr]

Use Fn+F9 key

[@zushaib]

sub single cells walay hen bhai multiple cells ka bhi bata do koi beginner bhi ho skta ha

[@Guptazone]

Single cell to multiple cell ,, how ?

[@Guptazone]

Iska just opposite kitna hai mujhe

[@rinapawar4364]

Not working this method in my data, Nothing has changed after using F9.. So please help me

[@PiyushPankajJr]

use F9 key with fn(function) key....

[@rinapawar4364]

Thank you Piyush

[@punaskar1]

Issee kahete hai excel ko pagal banake aapna kaam karwa lena... Badhiya

[@PiyushPankajJr]

😄😄😄

[@rakhimateti]

How to split single cells values into multiple cells

[@PiyushPankajJr]

Will share a video...

[@rakhimateti]

@@PiyushPankajJr For Example
1 Riding,
Jacket,
gloves
results should be
1 Riding
1 Jacket
1 Gloves
Hope you got my point

[@arjunthammisetty7219]

Calculate numbers kar saktha hai

[@k8055hsjshsn]

I have one question

[@PiyushPankajJr]

yes please

[@basantranga7839]

Can u share the formula ??

[@geetkhurana6644]

nothing is visible in your video, its corrupted

[@PiyushPankajJr]

Sorry Geet...
Can you explain what is the problem you face

[@angelinefernandes2329]

Hii can you teach in * * , in those * number* ,
Thank you

[@PiyushPankajJr]

Sure

[@angelinefernandes2329]

@@PiyushPankajJr thank you ...whn gonna load

[@PiyushPankajJr]

@@angelinefernandes2329 mid of october

[@angelinefernandes2329]

@@PiyushPankajJr pls do it soon na like 2 Oct pls

[@technicalsolution4911]

Sir agar single CELL ke data ko multiple CELL me move karna ho to kaise karenge

[@PiyushPankajJr]

Hi,
Use text to column function or split formula to split single cell value to multiple cell

[@k8055hsjshsn]

Hellow sir