How to Transpose collection as fist column become header.

[AbhimanyuThite]

Hi,
Is that anyone knows How to Transpose collection as fist column become header and respective columns are rows. Original Collection header should be removed.

If anyone has idea can you please help me.

Collection

Wanted Transpose Collection:

------------------------------
Abhimanyu Thite
------------------------------

[John__Carter]

If you look in the utility VBO there is an action called Transpose Collection that requires the input collection to have two columns, Name and Value. It may not be exactly what you're looking for, but if you need to create a bespoke solution, the code within this action may give you some inspiration.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[AbhimanyuThite]

Hi John,

Thanks for responding, this is not something I looking for please Check below screenshots, it creates two columns and one is for repeated the header and other has it values. I am trying something that 1st column should become a header.

This is My Collection:

After Transpose,

------------------------------
Abhimanyu Thite
------------------------------