Tony
I know you have your own transpose tool but I would strongly recommend you look at the Power Query approach
For info I've just written this thread at AWF based on the excellent suggestion by alansidman in post #9.
See Normalise Spreadsheet Data Easily Using Excel Power Query
Many thanks for this Alan ...and also for explaining what 'nun buoys' are in post #15 of another unrelated AWF thread What Do Nuns Do?
That thread is well worth reading for a laugh
For info I've just written this thread at AWF based on the excellent suggestion by alansidman in post #9.
See Normalise Spreadsheet Data Easily Using Excel Power Query
Many thanks for this Alan ...and also for explaining what 'nun buoys' are in post #15 of another unrelated AWF thread What Do Nuns Do?
That thread is well worth reading for a laugh
That's an excellent article thank you Colin. I still haven't got into it yet, but it's it's getting to the top of my list of things to do!
Tony,
To get started you may also want to pick up a copy of Ken Puls and Miguel Escobars book M is for (Data) Monkey. Its what got me started to use PQ. Amazing how powerful it truly is.
My link in pot #19 appears to be broken. Hopefully this one works https://www.access-programmers.co.uk...d.php?t=306580