Forum Discussion
BillyRaygun
5 years agoFrequent 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
- VijayPCommunity Champion
- VijayPCommunity Champion
Unpivot All Columns
Sort nulls to downRemove Rows from down
pivot back , it should help~
- BillyRaygunFrequent Visitor
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
- VijayPCommunity Champion
IF it works , you can mark this as solution ! Thanks