Transpose

[martina21]

Hi! I have here a sample data. I want the the Name, Group & Type to move to the header data.

I tried to transpose but I just want to transpose a selected data and multiple data. In transpose, it's only 1 value at a time. Can I do selected transpose in a column and multiple value too?

Data	Values
Name	Kris
Group	A
Address	USA
Age	12
Type	1
Name	Dave
Group	B
Address	Phil
Age	20
Type	2

Sample output should be like this

Data	Name	Group	Type
Kris	Kris	A	1
Dave	Dave	B	2

[Qiu]

@martina21 

Can we do the cross tab then select the data only we need?

[messi007]

@martina21,

Please see below how you can do it with multi-row formula and transpose 🙂

Attached the workflow,

Hope this helps,

Regards,