Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BillyRaygun
Frequent Visitor

Delete Multiple Columns

Good Morning,

 

After transposing my data, I have approximately 12,500 columns, with every 8th column null. Other than using the control button to manually select multiple columns, is there a way to select all the null columns simultaneously, so I can delete all at once?

 

Best Regards,

4 REPLIES 4
VijayP
Super User
Super User

@BillyRaygun 

IF it works , you can mark this as solution ! Thanks




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


VijayP
Super User
Super User

@BillyRaygun 

https://drive.google.com/file/d/1DmEP4RNf3H48nc1CpdTJkY2NrL8JXSea/view?usp=sharing

Watch this video 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


VijayP
Super User
Super User

@BillyRaygun 

Unpivot All Columns
Sort nulls to down

Remove Rows from down

pivot back , it should help~




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Thank you @VijayP 

 

I'm trying your suggestion. I haven't got it to work yet, but coming close.  I'll work it for a while longer, and update you here.

 

Best Regards

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.