topic RE: How to Transpose collection as fist column become header. in Product Forum

How to Transpose collection as fist column become header.

AbhimanyuThite — Mon, 11 May 2020 10:15:00 GMT

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
------------------------------

RE: How to Transpose collection as fist column become header.

John__Carter — Mon, 11 May 2020 14:47:00 GMT

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
------------------------------

RE: How to Transpose collection as fist column become header.

AbhimanyuThite — Mon, 11 May 2020 16:14:00 GMT

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
------------------------------