Forum Discussion

BillyRaygun's avatar
BillyRaygun
Frequent Visitor
5 years ago

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 t...
Tips and Tricks
VijayP's avatar
VijayP
Community Champion
5 years ago

BillyRaygun 

Unpivot All Columns
Sort nulls to down

Remove Rows from down

pivot back , it should help~

  • BillyRaygun's avatar
    BillyRaygun
    Frequent Visitor
    5 years ago

    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