Thank you, thank you, thank you! Just spent 3hours searching for the information you have so clearly and concisely delivered.
@DougHExcel2 жыл бұрын
Glad it was helpful!
@mohamedabdo-xg6tw2 жыл бұрын
just WOW! I have tried 8 different ways in Python and R and I couldn't get it. Thank you so much. I will definitely support your channel by buying you a coffee.
@DougHExcel2 жыл бұрын
Thanks so much for the support!!
@katefonzi36692 жыл бұрын
I have been trying to solve this problem for years! I needed something that someone with okay skills in Excel could replicate (with step-by-step instructions). Thank you so much, this is awesome!
@DougHExcel2 жыл бұрын
You’re welcome, feel free to share & spread the knowledge!
@blakewood47563 жыл бұрын
This was a life saver for something I had to do for work. Big thanks!
@DougHExcel3 жыл бұрын
Glad it helped!
@caithenry8429 Жыл бұрын
God bless you for this! This just saved me SO much time
@DougHExcel Жыл бұрын
Thanks Cait Henry, glad it helped!
@folorunsolala9672 Жыл бұрын
Thank you Thank you and Thank you. This is what i have been searching for. You made my day splendid
@DougHExcel Жыл бұрын
Glad it helped!
@JavierMadridC Жыл бұрын
This guy really deserves so much thumbs up!
@DougHExcel Жыл бұрын
Hi Javier Madrid, thanks for the kind words!
@user-ij2pi8se3x Жыл бұрын
truly straight forward and very clear now it is easy
@DougHExcel Жыл бұрын
Hi iTLeiffLotSix TadweerAlphamed, thanks for the comment!
@spencerpitcher84412 жыл бұрын
Is there a way to make this a dynamic function. Where when the parent spreadsheet is updated, the new table automatically updates?
@sureshsawant18973 жыл бұрын
When I m trying to solve ,(convert) line break data into multiple column numbers which seperated thru spaces are splitted but numbers which have last numer 00 not showing proper result as it display in line break data .....kindly advise what to do? Is is possible to send that example to u so that u can suggest better way to solve it?
@ariii64472 жыл бұрын
you are the best, thank you!!
@DougHExcel2 жыл бұрын
Hi Ariii, thanks for the kind words!
@alekm94463 жыл бұрын
Excellent explanations...
@DougHExcel3 жыл бұрын
Glad you liked it
@lukeh24403 жыл бұрын
If I could leave a million likes I would!!
@DougHExcel3 жыл бұрын
Hi Luke Hermes, thanks for the kind words!
@johnzehrbach8203 жыл бұрын
My work life it now complete!
@DougHExcel3 жыл бұрын
Hi john zehrbach, glad to hear 😁 thanks for the comment!
4 жыл бұрын
Hello. Very nice video, thank you. What if I have a lot of text in the cell and my separator is a blank line? I can't get it to work :(
@DougHExcel4 жыл бұрын
The line break method should have applied maybe I'm not understanding the question...
@mohammadkashkooly1987 Жыл бұрын
Thank you so much. I have dates separated by space then (e.g.10/6/22 10:45 [Level 3]) how do i do this please? Bunch of these some included text in other columns? Thank you
@DougHExcel Жыл бұрын
if it's textual and there's some pattern try kzfaq.info/get/bejne/qp54o7dqtZPWmZs.html
@ExceliAdam6 жыл бұрын
Why didn't you split by rows in Power Query? You have this option and you don't need to do unpivot columns.
@DougHExcel6 жыл бұрын
Excellent option...thanks for adding to the thread!
@roshanrewane71254 жыл бұрын
Hello I tried this option but it’s not working if We have () brackets in between, example 6441BY(6441BW) 6441BW(6441BY) In single cell and if I want to split that, please help me it’s urgent
@vaibhavsingh-dg6gm4 жыл бұрын
Thankyou so much, very helpful
@DougHExcel4 жыл бұрын
Glad it was helpful!
@abuzarchowdhury50895 жыл бұрын
Hi Douh, this is very useful video. Thanks for sharing with all. i have qus for you. i have data list and in a row with multiple lines and i want it to split in different columns. how would i do?
@DougHExcel5 жыл бұрын
if that video didn't work out, maybe some of the other one might give insight kzfaq.infosearch?view_as=subscriber&query=row+split+column
@winstonarockiaraj47364 жыл бұрын
Is there a way to split the quantity by the number of rows? say I have 20 as the quantity and it gets split into 4 rows, then i would like to see the quantity as "5" for each row... the value in quantity column should be divided by the number of rows for each item grouping, is that possible?
@DougHExcel4 жыл бұрын
Maybe, I think this would involved numbering the rows, a modulo function to have a pattern to group into 4s and then grouping.
@vincentgnapi71825 жыл бұрын
Took a couple replays to finally get it right but Thank you
@DougHExcel5 жыл бұрын
You're Welcome!
@Luciano_mp6 жыл бұрын
É de grande ajuda. Obrigado Doug.
@DougHExcel6 жыл бұрын
De nada! Obrigado!
@chesterumali92264 жыл бұрын
Ctrl + J isn't working. How do I delimiter if the values are separated by a new line? like 3 lines within a cell. Normally ctrl J would work in the normal text to column but not in power query. Thanks!
@DougHExcel4 жыл бұрын
should work...try Ctrl+J in word and copy it over could be a test...
@mohamedchakroun49736 жыл бұрын
Thank you for the ctrl j refresh, i forgot it :-)
@DougHExcel6 жыл бұрын
Hi Mohamed Chakroun, glad you liked it, thanks for commenting!
@abhijeetpatre33275 жыл бұрын
Thank you so much man!
@DougHExcel5 жыл бұрын
You're welcome!
@sevainternet13833 жыл бұрын
very useful
@DougHExcel3 жыл бұрын
Glad you think so!
@ksawesome153 жыл бұрын
What if I'm trying to have multiple separate rows into one single cell? Like I still want the rows to be separate so its tiny cells into one big cell?
@DougHExcel3 жыл бұрын
Maybe this vid will help kzfaq.info/get/bejne/eN52ocRkl7-rfok.html and use the Split using special characters option.
@bodavinay44204 жыл бұрын
You are amazing.!!
@DougHExcel4 жыл бұрын
Wow, thank you!
@Meolimo6 жыл бұрын
Nice Doug thanks !
@DougHExcel6 жыл бұрын
Hi Mario Limoges, thanks for the comment!
@Meolimo6 жыл бұрын
c'est moi qui te remerci :-)
@vietanh-sungroup80484 жыл бұрын
thanks! Sir
@DougHExcel4 жыл бұрын
Most welcome!
@bernardblumberg8036 жыл бұрын
Great Stuff.,
@DougHExcel6 жыл бұрын
Thanks Bernard Blumberg!
@yotarius34174 жыл бұрын
it is ctrl+j for people who don't wanna sit here for 10 minutes
@DougHExcel4 жыл бұрын
Hi eli clay, thanks for adding to the thread!
@jasonv72284 жыл бұрын
what would you put in for a mac?
@DougHExcel4 жыл бұрын
Depends on what version , the PQ features recently became available for MAC and though most of the features have parity with the Windows version, they commands may be in different places...so you'd have to look for them
@EngineeringTR3 жыл бұрын
let's say: from 0001 to 1000 in different cells suhc as (A1=0001,A2=0002,... A999=0999, A1000=1000) --> how is it made that these will only be in one cell as: 0001,0002,0003,...,0999,1000
@DougHExcel3 жыл бұрын
maybe one of these kzfaq.infosearch?query=textjoin
@waleedaljuhaishe75913 жыл бұрын
I have very complicated excel sheet, would please help me solving it?
@DougHExcel3 жыл бұрын
Hi Waleed AlJuhaishe, sorry 🙁....but try a post on the mrexcel.com forum!
@singhalmonica4 жыл бұрын
Can't we do it by formula.....
@DougHExcel4 жыл бұрын
probably...but it could be a bit more complicated...
@singhalmonica4 жыл бұрын
@@DougHExcel ok, pls update me, will it work if we add new data in master sheet....