Row to Column

Question

Hello,

I would like to transpose this rows into column. I have try to use the transpos tool without success. Here you can find an example o what I want to have

Input:

Name_Column_1       Name Column_2        Name_Colunm3

Pierre gally

Juliette Harry

GeorgeExam

Output:

Name_Column_1       Name Column_2        Name_Colunm3

Pierre gally             Juliette Harry            GeorgeExam

Thanks in advance for all your answer,

Best regards,

AngelosPachis · Answer

Hi @Tommy23 ,

I think you have to form new column headers for the transpose tool to work, because only one of your columns originally contains data.

example.yxmd

JagdeeshN · Answer

@Tommy23

Please find attached a sample workflow. With regards to the name of the columns you can handle that in the select after the crosstab.

Let me know if this helps.

Best,

Jagdeesh Narayanan

sample.yxmd