You are reading a single comment by @Chalfie 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.
@Chalfie
No probs. If you don't want to touch your data which comes in a tidy format in G12:J74 right?
So.
First things:
Where does this data come from?
Keep that as your raw data.
Then use power query (https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a)
to find and import your data into a new book or new sheet (probably new book)
Then use pivot columns (https://support.microsoft.com/en-us/office/pivot-columns-power-query-abc9c8da-3be9-44c4-886e-0be331ab387a)
to turn your long data into wide data so that you read it like a human and have it as a calendar.
By using power query as part of your ETL (extract, transform, load) you can add 1000million bonus points to your CV. And also make things a bit more "automatic".