VBA for Transforming Tables

I need help to transform the attached table: original data in column A-D and example of desired outcome in column F-G.

Thanks for help

See my post here. Its possible to do this with a formula. It would likely be easier to update and fix, alter, etc. In addition you would not need to save as xlsm and no one would need to enable macros to use it.

Ill see if I can add a response here with the formulas updated to your needs.

Hell, I may have found a simpler way to do it, at least in your case. I have attached my efforts, but I will explain what I did as well.

In I1 i did (filled down):

Formula:

Please Login or Register  to view this content.

This gives use the headers repeating filled down G1,G2,G3,G4,G1,G2,G3,G4...

Then in J1 (filled down):

Formula:

Please Login or Register  to view this content.

This essentially starts at the first time under the proper header and increments down the list according to the count of that header in Column I from the start (J1) to J whatever the current row is.

You will have to fill these as far down as required to complete the sequence, after which you will likely get blanks (or whatever you have typed under your table). You can see in my sample it start bringing in ---- and then 0's. The headers will just alternate til the end of time (as far down as you fill them).

Hope this helps.

My problem is not solved using your suggestion. I need to keep all records in that order as shown in my original data sample. It should be a VBA to it rather than using formula. Thanks for your help.

Originally Posted by Ucpaul

My problem is not solved using your suggestion. I need to keep all records in that order as shown in my original data sample. It should be a VBA to it rather than using formula. Thanks for your help.

Not sure I follow your explanation of how it doesn't work. My results look like this:

Capture.PNG

My results match yours exactly Columns I:J are identical in content to F:G, minus the formatting which could simply be done as a conditional format. If you have your heart set on a macro, thats fine...but I dont see where this isnt producing the same results as your sample.

Yes, you're right. Sorry that I opened the file from your previous post (not this one). Your formula works! Thanks for help

This Macro is perfect!. Thanks for help