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.
Solved! Go to Solution.
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
@fmvizcainoHave you looked at using the tile tool set to unique value to do the job of the multi-row? I know the multi-row is like muscle memory at this point but wow... that tile tool is just so quick.
Yes, I use that tool all the time, but for some reason I wasn't able to see that working for this case.
Maybe because it is late, who knows hahahaha