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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.