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

[@joedas7648]

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

[@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!!!

[@sonamtiwary6338]

Really super information sir

[@SueBaker-k8j]

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.

[@Trainee..._____07]

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

[@akshayvibhandik0205]

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

[@Trainee..._____07]

Bahut bahut dhanyavaad

[@prudhvinerella4201]

Thanks brother, it helps

[@sagarrawat2362]

Thanks buddy 😊

[@rakibislam4742]

Thanks a lot...

[@Jaykumar-vj4cy]

Bahut bahut dhanybad sir

[@manojkumarnayak8311]

Thanks for your help

[@motivationsuccess863]

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

[@PiyushPankajJr]

Use Char(10) Formula for line break and after using formula wrap test that cell, you will get values in vertically

[@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

[@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

[@ahmadfaraz2962]

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

[@ATInstitute]

Thank you... you are a life saver

[@manateluguinfo8253]

Very useful sir... Thank you guruji🙏

[@manojgarg7684]

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

[@Anandmoto]

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

[@chandrasekhardurgaprasadd8878]

Really superb boss
Thank you so much

[@Russty_copper]

Genius

[@Nowcreates]

Exactly what I needed! Thanks.

[@financialguru8269]

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

[@therutujajere252]

Informative ✌✌

[@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.. 😄

[@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

[@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

[@technicalsolution4911]

Pls iske liye Bhi 1 video banaye sir

[@patturoxxxx]

great trick, not many ppl know abt it

[@kamrulislam648]

Great video, helps me a lot, Subscribing you

[@PiyushPankajJr]

Thanks Kamrul:)

[@naveedalijamali4414]

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

[@ParaskumarKumar]

So Helpful 👌

[@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

[@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

[@GIS-Engineer]

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

[@pankajsaini50]

Thank you sir

[@mugdhanaik7241]

Great video. Thanks a lot. Very helpful

[@PiyushPankajJr]

Thanks for your feedback...🙂

[@akshayzalte9274]

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

[@PiyushPankajJr]

Use Char(10) Formula for line break and after using formula wrap test that cell, you will get values in vertically

[@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

[@AG-hc8nz]

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

[@karishmathakur3349]

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

[@PiyushPankajJr]

Use Fn+F9 key

[@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]

[@Guptazone]

Single cell to multiple cell ,, how ?

[@PiyushPankajJr]

Use text to column function

[@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

[@sidkhan9871]

Nice

[@punaskar1]

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

[@PiyushPankajJr]

😄😄😄

[@iram5692]

Agr ak cell ma do amonts likh k jma krni hon

[@zushaib]

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

[@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

[@raviiMaurya]

finally😅😅😅

[@k8055hsjshsn]

I have one question

[@PiyushPankajJr]

yes please

[@basantranga7839]

Can u share the formula ??

[@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

[@Guptazone]

Iska just opposite kitna hai mujhe

[@PiyushPankajJr]

use text to column and then apply tocol function

[@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

[@geetkhurana6644]

nothing is visible in your video, its corrupted

[@PiyushPankajJr]

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

[@arjunthammisetty7219]

Calculate numbers kar saktha hai

[@k8055hsjshsn]

Hellow sir