Summary Sheet.PNG - Summary Sheet
Apprentice Sheet.PNG - Apprentice Sheet
I am trying to take every 4th value starting on row 3, cell B3 from the Apprentice Sheet and transposing it onto my Summary Sheet in a column. I have been trying to use the index and offset functions but have been unsuccessful. Any help would be much appreciated.
I've also posted this question on StackFlow but someone recommended Power Query. This is not something I want to delve into when I am on a time crunch.
stackoverflow.com/q/50761004/9914096 - this is the link without the http beginning. I'm told I'm not allowed to post links without having posted a few times. So many rules, lol!
Bookmarks