I am trying to convert the following format of records:

enter image description here

To a flat record, like the below, using VBA.

enter image description here

Please could you give me some pointers on how to begin this using VBA?

New contributor
JamieFearon is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • If you are able to try PQ (powerquery) I'm prety sure it's just a few clicks :). How set are you on using VBA? – JvdV Aug 14 at 9:00
  • Does the amount of blocks to be converted to flat form is constant (as in sample data - 3)? – Akina Aug 14 at 9:23
  • how to begin this using VBA? Get header data into array, extract dates and define blocks amount. Get all data into array, copy it into another array with proper reordering and add dates, store it to another worksheet. – Akina Aug 14 at 9:26

Your Answer

JamieFearon is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.