Use of VBA code or otherwise

[Jar888]

Hi there, is there a way to use VBA code or otherwise to make the left hand side look like the right as per the example excel snip I've attached?

I pull the data in at the moment as a block from another sheet into the left hand sides format. The only thing I really care about is the drill/single/twin/cut&drop numbers though. Everything else is mute. But the tricky part comes where the name might not match the heading in the same row. Generally speaking, each 4 rows of a machine are operated by the person at the top of the machine# and the others are just trainees.

 

[Peter_SSs]

Sorry, no. I displayed the 6 dates at the start, then #N/A for operator and blank everything else.

I copied you data from the XL2BB post to my test sheet, ran the code and got identical results to what you posted on the right.

What happens if you copy your own sample data from post #5 to a blank worksheet, using this icon at the top-left ..

.. clear columns P:AA and then run the code?

If that is not working for you then something must still be different between our worksheets. Perhaps it relates to those formulas that you mentioned.
Is it possible for you to upload the sample file, with formulas from linked sheets (& therefore also the linked sheets) included, but any sensitive data disguised, to DropBox, OneDrive etc and provide a shared link here in the forum?