Changing column to header using cross tab tool

[Sshasnk]

I have two columns which I have to change it into header and value but I am only getting one row in return

Values_column	value
Name	emily
Lastname	ross
File	pdf
Phonenumber	124
address	london
Name	brad
Lastname	gill
File	excel
father	nick
Phonenumber	854
address	Bakers street

it above column emily does not have column father so it should be null

output:

Name	Lastname	file	father	phonenumber	address
emily	ross	pdf		124	london
brad	gill	excel	nick	854	Bakers street

[messi007 · Accepted solution]

Dear @Sshasnk,

below the solution 🙂

Attached the workflow, please mark it as solved if that solve the problem 🙂

Regards,

[Qiu]

@Sshasnk 

A bit different approach with @messi007 

[atcodedog05]

Hi @Sshasnk 

Here is a workflow for the task.

Workflow:

Pretty much the same have just sorted the columns.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍