Download the file ⬇- goodly.co.in/wp-content/uploads/2023/10/Remove-Top-Junk-Rows-and-Combine-Data.zip each in Power Query - th-cam.com/video/IHgHvHaWfpM/w-d-xo.html
Hi Bro, You have explained in very easy way, Kindly upload one more video on each and (_) underscore in Hindi as well. How does this concept work, It's very complicated to understand for beginners... Thank you so much Bro again.
बहुत सुंदर । इसको if यूज करते हुए पहले कॉलम से नया कॉलम बनाए । जिसमें कॉलम 1 = डेट, else null result लाकर । Null result के अलावा डेट मिलते ही skip command को उपयोग करना बताए प्लीज
Hey, Awsome tutorial, this time you have used a different approach for finding headers, in your english tutorial you used List.ContainsAny and now more simpler and easy way of {"headers"}. Great. I want to know how can we achieve this objective if we want to remove rows from the bottom up-until a certain row which contains some specific text. Thanks in advance
Download the file ⬇- goodly.co.in/wp-content/uploads/2023/10/Remove-Top-Junk-Rows-and-Combine-Data.zip
each in Power Query - th-cam.com/video/IHgHvHaWfpM/w-d-xo.html
Hi Bro, You have explained in very easy way, Kindly upload one more video on each and (_) underscore in Hindi as well. How does this concept work, It's very complicated to understand for beginners... Thank you so much Bro again.
Awesome video and you explain smoothly.
One question:
What if there is an error in the column header name in one of the Excel files?
बहुत सुंदर ।
इसको if यूज करते हुए पहले कॉलम से नया कॉलम बनाए । जिसमें कॉलम 1 = डेट, else null result लाकर । Null result के अलावा डेट मिलते ही skip command को उपयोग करना बताए प्लीज
Hey, Awsome tutorial, this time you have used a different approach for finding headers, in your english tutorial you used List.ContainsAny and now more simpler and easy way of {"headers"}. Great. I want to know how can we achieve this objective if we want to remove rows from the bottom up-until a certain row which contains some specific text. Thanks in advance
You may also use function =Table.Skip(Sheet2_Sheet, each [Column2]null) to remove any number of junk rows ))