Thanks for the tips. I've done a slightly shonky iterative version of this.
Going try and redo it in power query in a tidier format as the ultimate aim is a list with ancillary fields to be uploaded to a workaround tool. And obvs only 1/10 of the fields share the same naming convention ðŸ«
Thanks for the tips. I've done a slightly shonky iterative version of this.
Going try and redo it in power query in a tidier format as the ultimate aim is a list with ancillary fields to be uploaded to a workaround tool. And obvs only 1/10 of the fields share the same naming convention ðŸ«