How to change columns values to rows ?

[vkumarhit]

Hi Designers,

Can you provide me the solution to get the name column as Row headers.It should be like 

id,fullname,birthcountry,motivation,year,birthdate

1,wilhelm conrad,Germany,"in recog",1901,null

2 ............................

3...............

[ShankerV]

Hi @vkumarhit 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @vkumarhit 

Have checked with little extensive dataset.

[ShankerV]

Hi @vkumarhit 

If you need to reflect the null() in the output.

Added the filter tool to achieve the result.

Many thanks

Shanker V

[vkumarhit]

And if we want to give first row as header and segment it?

[ShankerV]

Hi @vkumarhit 

As per the input shared, I have used the same as header in the workflow too.

Hope it helps!!!!

[Raj]

use the dynamic rename tool to make first row as header

[ShankerV]

Hi @vkumarhit 

Expecting the result like this?

[vkumarhit]

I just want to separate the columns and group it by id

[Raj]

You need this as solution as guess

but you should not use this for exam purpose.