@ 2:22 = Using Table.ColumnNames(DoubleBarrelHeader) as the 2nd argument (a list) for the Table.FillDown function! That's a new one to me. Table.To(From)Columns functions! Amazing video, indeed. THANK YOU James.
You are a very good teacher and guide. I watched just one video on your channel and subscribed immediately, and this is the first time this has happened to me.
Awesome tutorial. I like this technique and use it a lot. And your style of explaining is great. And, wow, we've posted a tutorial on the same topic almost at the same moment but the approaches are so different. I've used a double transpose thingy which is ok for little datasets but a bit ineffective with large ones.
Targeted exactly what I was trying to figure out. First time viewer. Subscribed immediately. Let's grab a cuppa Earl Grey sometime. Lemon, of course, not milk.
WOW greate tip 👍👍 How about performance in place of conwerting table->lists->table ? to this day I've done it by combining table with one row (headers to promote it later) and table with data (3rd+ rows)
Hi James at 2:10 for Fill Down query, If I right click to Fill down, and the script would look like below. It looks like it works the same as yours. Am I correct? = Table.FillDown(DoubleBarrelHeader,{"Column1"})
Hi, your method will fill down only the first column (Column1), and James fills down all existing columns at the same time with his code. It can be very convenient if the header is even more complex. On this data set both will get you the same result, because Cloumn2 doesn't have null values.
@@howtolearnexcel Thanks! Crispo. Just took a look at your YT channel and PQ Challenges and submissions from PQ experts on LinkedIn. Interesting answers on Challenge 15.
@@txreal2 Hi! Thanks for the comment, but it looks like you might have mixed me up with someone else. I’m Yaroslav. I occasionally participate in PQ challenges created by Crispo, Omid, and Vijay and make videos with my solutions and comments. If you’re looking for Crispo’s content, his channel is @crispexcel, and it's definitely worth checking out!
I wish I could get to grips with unpivot / pivot, i will write dozens of lines of code to avoid using it, just cannot visualize in my head what I'm trying to do.
@ 2:22 = Using Table.ColumnNames(DoubleBarrelHeader) as the 2nd argument (a list) for the Table.FillDown function! That's a new one to me.
Table.To(From)Columns functions! Amazing video, indeed.
THANK YOU James.
You are a very good teacher and guide. I watched just one video on your channel and subscribed immediately, and this is the first time this has happened to me.
You are too good 👍...Great MCodes demonstrated here ... looking forward for more like these ...Thank you
glorious!
Thank for sharing. Excelent and useful tip
ВA Sensei ! You are the Best ! Thank you very much !
Thank you very much!
Best video, simple & quick 😍
Glad you liked it!
Indeed, excellent!!!
Excelente video. Gracias por compartir
Awesome tutorial. I like this technique and use it a lot. And your style of explaining is great.
And, wow, we've posted a tutorial on the same topic almost at the same moment but the approaches are so different.
I've used a double transpose thingy which is ok for little datasets but a bit ineffective with large ones.
did you transpose whole table or rows with headers?
@@sledziu32 I've transposed the whole thing. It works well, if a table isn't large.
awesome!
great as always❤, thanks James
glorious thank man!
Excellent! Thank you!
Targeted exactly what I was trying to figure out. First time viewer. Subscribed immediately. Let's grab a cuppa Earl Grey sometime. Lemon, of course, not milk.
glorious thank you!
WOW greate tip 👍👍 How about performance in place of conwerting table->lists->table ?
to this day I've done it by combining table with one row (headers to promote it later) and table with data (3rd+ rows)
Good trick! Would it be easier to append the merged column without converting to list to the source, after skipping the first two rows?
Hi James at 2:10 for Fill Down query,
If I right click to Fill down, and the script would look like below. It looks like it works the same as yours. Am I correct?
= Table.FillDown(DoubleBarrelHeader,{"Column1"})
Hi, your method will fill down only the first column (Column1), and James fills down all existing columns at the same time with his code. It can be very convenient if the header is even more complex. On this data set both will get you the same result, because Cloumn2 doesn't have null values.
@@howtolearnexcel Thanks! Crispo.
Just took a look at your YT channel and PQ Challenges and submissions from PQ experts on LinkedIn.
Interesting answers on Challenge 15.
@@txreal2 Hi! Thanks for the comment, but it looks like you might have mixed me up with someone else. I’m Yaroslav. I occasionally participate in PQ challenges created by Crispo, Omid, and Vijay and make videos with my solutions and comments. If you’re looking for Crispo’s content, his channel is @crispexcel, and it's definitely worth checking out!
I wish I could get to grips with unpivot / pivot, i will write dozens of lines of code to avoid using it,
just cannot visualize in my head what I'm trying to do.
each Text.Combine(_, "|"), "MergedColumn")[MergedColumn]
[MergedColumn] - converts the MergedColumn table into a list
Awesome! Thanks.