Converting horizontal Excel data with monthly periods into vertical Access database records

[isladogs]

Tony
I know you have your own transpose tool but I would strongly recommend you look at the Power Query approach

[Uncle Gizmo]

Tony
I know you have your own transpose tool but I would strongly recommend you look at the Power Query approach

Yes! Definitely Colin, it's something new to me and I want to get "Power Query" under my belt!

Sent from my Pixel 3a using Tapatalk

[isladogs]

I'm going to write a detailed explanation about this in the next few days for posting at AWF

[isladogs]

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

[Uncle Gizmo]

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!

[isladogs]

You're welcome. Hopefully it will all be clear when you try it out yourself.

[alansidman]

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.

[isladogs]

My link in pot #19 appears to be broken. Hopefully this one works https://www.access-programmers.co.uk...d.php?t=306580