Analyze data in specific way

[YasserKhalil]

Hello everyone
I need to analyze and split data in specific way
In fact it is hard to describe my issue ... so I have attached the expected output in "Final Sheet" starting in Column K till column Y
Hope it is clear (see the attachment)

[antoka05]

See attached file, this the code that I used:

Please Login or Register  to view this content.

Regards,
Antonio

[YasserKhalil]

Thanks a lot Mr. Antonio for this awesome and fascinating code
Just a little remark ..
There is Event 33 repeated at all events at the beginning of each group
Take a look at the results

[antoka05]

Excuse me, in my code there was one error:

Please Login or Register  to view this content.

The right code is:

Please Login or Register  to view this content.

Regards,
Antonio

[YasserKhalil]

Thank you very much for this distinguished solution
It's perfect
Regards

[xladept]

Hi Yasser,

Here's mine:

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much Mr. aka Orrin (Is that your real name?)
you provided me a great solution too ..
Thanks a lot for this great and wonderful help
Regards

[xladept]

Hi Yasser,

You're welcome and thanks for the rep - here's a correction for the ", 6 Oct:

Please Login or Register  to view this content.

* Yes, Orrin is my real name (it means "Fair One" in the Welsh from which it was derived) - Does Yasser mean something??

[YasserKhalil]

Thanks a lot Mr. Orrin for correction
As for my name it means in Arabic (my language) the easy man ... What about aka (is this a name? or what?)

[xladept]

Hi Yasser,

AKA is a mnemonic for "Also Known As" it is used to describe an entities alias

The easy man? - You're projects are normally fairly complex