Transpose

[Anthony_white]

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. 

[binu_acs · Accepted solution]

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

[amjadmanasra]

Hello

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

[Emmanuel_G]

@Anthony_white 

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

[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.