You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
greentricky
@hugo7
https://docs.google.com/spreadsheets/d/1S8I1DwLBInGWNBN9yLSOf9h2rxqyhwjlNJlbmeChKag/edit?usp=sharing
I have a list 300 of names with >300 columns contianing their access roles that have been created using formulas
The data I've ended up with means that there are blank spaces mixed in all over the place - a bit like the pic / link.
How do I tidy it?
Previously I the way I'd written my formulas meant (by luck) all rows with data I didn't need = 0 and the columns I didn't need = #n/a so I could just "find all" and delete each group consecutively. But since tidying my formula I now have null values all over the place.
Any ideas?
I started looking at power query, but tbh I need a bit of time to learn the principles.