Transpose

I'm ashamed to be asking this. How do you transpose vertical columns without concatenating the cells into a single cell? When using the transpose or cross tab tools I end up either losing cells or concatenating them. Below is similar to what I am trying to accomplish.

Developer

Developer Tools

Accepted answers

binu_acs

@Anthony_white One way of doing this with the cross tab tool

Brand_!013.yxmd

All comments

binu_acs

@Anthony_white One way of doing this with the cross tab tool

Brand_!013.yxmd

amjadmanasra

Hello

another way to do this is by duplicating your value and using it in the crosstab

QuestionResponse.yxmd

Emmanuel_G

@Anthony_white

Another way of doing that just with formula tool in addition.

Transpose.yxmd

Anthony_white

This worked perfectly! What I was having issues with was the headers because what I am actually transposing are directory paths, which make a mess as a header.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703