Removing unwanted data

[Ab02]

Hello,

I am a beginner with Alteryx. I have the following table:

After removing the unwanted data, I would like to have a result like the one below:

Thank U for your support.

[mceleavey]

Hi @Ab02 ,

This is a simple multi-field formula:

Hope this helps,

M