Sorry, first post so forgive me if I get anything wrong.
I am a fairly experienced excel user and happy to use any formula for my requirements I'm using 64 bit Excel 2016.
My issue is trying to transpose large amounts of data using a formula (vlookup/hlookup/index match are in my mind but not...