cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.