Excel Table Manipulation

Help
, , , ,
1

Hello All,

image

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

Thanks for the feedback :slight_smile:

2

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

3

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:

image
image222×643 5.08 KB

4

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