Transpose column to row in DataTable

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

OutputDT

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

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

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.

Thanks & Regards,
Navneet :slight_smile:
Happy Automation!

Check this below link, @NavneetPanpaliya


This may help you :slight_smile:
1 Like

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

1 Like