Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
IF it works , you can mark this as solution ! Thanks
Proud to be a Super User!
https://drive.google.com/file/d/1DmEP4RNf3H48nc1CpdTJkY2NrL8JXSea/view?usp=sharing
Watch this video
Proud to be a Super User!
Unpivot All Columns
Sort nulls to down
Remove Rows from down
pivot back , it should help~
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |