Having issues with the tranpose tool

Question

Hi All,

Thank you for taking time to help me out with my issue. Currently, I have this table where rows 1-3 should be grouped together and transposed. This is the input:

Ideally, I want to transpose it and make it look like this:

Essentially, this is what I want to do:

I have attached a dummy workflow below. I'm having a lot of issues doing such so if anyone could help me, that'll be greatly appreciated!

Thank you in advance.

Horizontal Union.yxmd

apathetichell · Accepted Answer

see attached - tile tool really helps after transpose and before crosstab. minor datacleansing.

fmvizcaino · Accepted Answer

Hi @Andyhjtran ,

Here is an example for you.

The multi-row is being used to create an ID for each repetition of the header columns, that way we can play with the cross tab and transpose tool to achieve exactly what you want.

Best,

Fernando Vizcaino