This is awesome, it removes a lot of manual editing I have to do when people feed me data with blank columns in random spots every month that I then have to remove later. Thanks!
Glad to hear it helps you save time! Similar result can be achieved through python pandas, especially if the dataset is big, which power query is slow to handle.
Good solution. If you want to remove just blank columns you could also transpose then just apply the Remove Rows>Remove Blank Rows which results in a cleaner formula. I do like the flexibility of your solution though to remove columns with only 1 entry.
Great solution! Just wondering, what would you recommend if my dataset exceeds the column limit? Asking because I'm working with a dataset with +80k records and need ideas. Thanks!
Hello Ivan, Thank you for the positive feedback, it means a lot. For dataset with 80k+ rows, I would recommend using either R or python. R I have observed to be significantly faster in loading data compared with python pandas, you can try out both if you need more help, leave a comment.
After playing around with it, if you demote the columns (select the Use Headers as First Row option), then do everything in the video, and then promote the columns (Use First Row as Headers) you'll keep your headers!
This is awesome, it removes a lot of manual editing I have to do when people feed me data with blank columns in random spots every month that I then have to remove later. Thanks!
Glad to hear it helps you save time!
Similar result can be achieved through python pandas, especially if the dataset is big, which power query is slow to handle.
Excellent solution - this saves me a ton of time!
Thank you, I'm glad you found it helpful.
Make sure to check out other videos and leave feedback.
Good solution. If you want to remove just blank columns you could also transpose then just apply the Remove Rows>Remove Blank Rows which results in a cleaner formula. I do like the flexibility of your solution though to remove columns with only 1 entry.
Great idea, Tim, Thank you.
And make sure to check out my other videos on the channel as well.
Great solution! Just wondering, what would you recommend if my dataset exceeds the column limit? Asking because I'm working with a dataset with +80k records and need ideas. Thanks!
Hello Ivan,
Thank you for the positive feedback, it means a lot.
For dataset with 80k+ rows, I would recommend using either R or python. R I have observed to be significantly faster in loading data compared with python pandas, you can try out both if you need more help, leave a comment.
Good solution, except you lose the column headers. Is there a way to do this without having to rename every column back to what it was?
Thanks Evan, let me look into it and get back to you.
Hi, this is also what I am curious about? Everything else works fantastically, but I do need to keep my headers.
After playing around with it, if you demote the columns (select the Use Headers as First Row option), then do everything in the video, and then promote the columns (Use First Row as Headers) you'll keep your headers!
Thank you Ramisa, thats a great solution.
I found a workaround but your solution seems much better and elegant, appreciated!
@@theDataCorner Happy it worked out :)