Transpose column to row in DataTable

Help Studio
, ,
1

Hello Frients,

I want to transpose column to row and also concatenate values by semicolon separated. Here is example. I can transpose column values for first 2 rows but how can I build 3rd column from rest of the rows?

InputDT

image
image872×126 3.22 KB

OutputDT

image
image708×128 3.4 KB

P.S: I built empty dataTable to have column names in OutputDT.

@Palaniyappan: Can you also help me achieving required output?

Thanks & Regards,
Navneet :slight_smile:
Happy Automation!

1 Like
2

Hy @NavneetPanpaliya,

Please check the attached workflow. I believe it is what you are looking.

DataTableTranspose.zip (38.2 KB)

Please let me know if it works.
Any question please let me know

Regards

2 Likes
3

Hello @William_Blech_Sister,

Thanks for your quick solution.
However I was able to implement the same solution but if you look at the 3rd column in the OutputDT mentioned in my post which is what I am trying to achieve.
In 3rd column from 3rd row onward all values are semicolon separated.

Using your solution I am getting below output.

image
image1023×128 3.79 KB

Thanks & Regards,
Navneet :slight_smile:
Happy Automation!

4

Check this below link, @NavneetPanpaliya

This may help you :slight_smile:

2 Likes
5

Hy @NavneetPanpaliya,

Very glad I could help you! Please like my post, it helps me.

Well done you could figure it out on your own!

Happy Automation

3 Likes