Combine and transpose parts of a data table as columns

[anhdo92]

Hi,

I'm struggling to combine and transpose some parts of the following dataset...

And below is the final output I wanna achieve

Any idea is very much appreciated!

Thanks,
Anh

[fmvizcaino · Accepted solution]

Hi @anhdo92 ,

Attached is an example showing how to achieve what you are looking for.

Let me know if that works for you.

Best,

Fernando Vizcaino

[afv2688 · Accepted solution]

Hello @anhdo92,

Here's another way to do it.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[anhdo92]

Thanks a lot guys! @fmvizcaino  @afv2688