How can I transpose 2 dimensions data to rows

Question

Hi everyone, I'm sorry for my bad English. I've tried to find the solution for this but didn't work so I post this message for your help.I have this data:&nbsp;Name&nbsp;&nbsp;&nbsp; &nbsp;a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/1&nbsp; &nbsp; &nbsp;12/1&nbsp; &nbsp; &nbsp;13/1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a2&nbsp; &nbsp; &nbsp; &nbsp; a3&nbsp; &nbsp;b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/2&nbsp; &nbsp; &nbsp; &nbsp; 2/2&nbsp; &nbsp; &nbsp; 3/2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b2&nbsp; &nbsp; &nbsp; &nbsp; b3&nbsp; &nbsp;c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/1&nbsp; &nbsp; &nbsp; &nbsp; 3/1&nbsp; &nbsp; &nbsp; 4/1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c2&nbsp; &nbsp; &nbsp; &nbsp; c3What I'm looking fora&nbsp; &nbsp;11/1&nbsp; a1&nbsp;a&nbsp; &nbsp;12/1&nbsp; a2a&nbsp; &nbsp;13/1&nbsp; a3b&nbsp; &nbsp;1/2&nbsp; &nbsp;b1b&nbsp; &nbsp;2/2&nbsp; &nbsp;b2b&nbsp; &nbsp;3/2&nbsp; &nbsp;b3c&nbsp; &nbsp;2/1&nbsp; &nbsp;c1c&nbsp; &nbsp;3/1&nbsp; &nbsp;c2c&nbsp; &nbsp;4/1&nbsp; &nbsp;c3&nbsp;I would like to say thanks in advance.&nbsp;

mariusz · Accepted Answer

Hi&nbsp;huynq&nbsp;
&nbsp;
Try this script or see the attached for the solution.
&nbsp;
&nbsp;
Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me. LinkedIn 
&nbsp;

Forum Discussion

How can I transpose 2 dimensions data to rows

2 Replies

Related content

Help Transposing

Transpose data

Transposing Data

degenerate dimensions

Transpose data