You are reading a single comment by @Dugtheslug 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.
Dugtheslug
aggi
That's a horrendous layout for doing anything with. Much better would be a date in column A, a category in B (use a drop down to make sure they're consistent) and a value in C.
Easiest way to get to this is to unpivot using power query.
This is a random guide I found on Google
https://exceloffthegrid.com/power-query-unpivot-data/
But searching "unpivot using power query" will give you plenty of guides