Excel Table Manipulation

Hello All,


I would like to know how to convert from column to row like in the picture above ?

Thanks for the feedback :slight_smile:

I recently had this issue. Hopefully following the same format this method works for you :slight_smile: transpose.zip (17.4 KB)

Thanks for the info.

But how to make it clean ? I have to much information on the newly created sheet. And how can it iterate through the next column ? Because on the add data row activities, I am specifying the column index. (Sorry, since I am new so I couldn’t upload my process) :sob:

There is an activity called remove duplicate rows. Have a look in the properties and see if that is what you were after