Delete Multiple Columns

[BillyRaygun]

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,

[VijayP]

@BillyRaygun 

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

[VijayP]

@BillyRaygun 

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

Watch this video 

[VijayP]

@BillyRaygun 

Unpivot All Columns
Sort nulls to down

Remove Rows from down

pivot back , it should help~

[BillyRaygun]

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