How to Split 1 column into 2 column Excel in Uipath (the Column is WrapText)

Help Activities
,
1

Hi All,

I’m having some issue to split the column from 1 to 2 as the column is under all WrapText, is anyone can help me on this? I have attached the Excel file as below.

Sheet 1 is the original data I have
Sheet 2 is the result I need.
Appreciate your help on this issue. Thanks.
Data.xlsx (11.4 KB)

1 Like
2

Hi @Srini84 Expert, Appreciate your help for this issue again. Thanks

3

Hi @Parth_Doshi Bro, hope you can help me on this issue.

4

@ack940129

Try as below

Build a datatable and split as below

image
image985×650 21.4 KB

After that using Write Range activity you write to sheet2

Hope this helps

Thanks

1 Like
5

Hi @Srini84, You are the best! This is work perfectly now!

2 Likes
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.