shaping Data

[Simon1187]

Hi everyone!

I have a list. The screenshot is below. 

I am trying to achieve like the screenshot below. 

Could you please help me with that? 

Thanks

[Qiu]

@Simon1187 
With the data you provided, I believe I can only provide a very static solution.
If you can provide some real data, if that is possible, more dynamic flow might be possible.

[Simon1187]

Hi@Qiu, 

Thanks. 

Please see the attachments. 

[cmcclellan]

In Alteryx, columns cannot have the same name ... 

[AZuc]

@Simon1187 

You can use report tools to help on formatting.