Convert single column values into multiple columns

Help Something Else
1

Hello Everyone,

image
image582×558 8.98 KB

This is sample sheet. So, here the single column value i.e. leave type should be separated into multiple columns and the value in column 3 should be inserted in separate columns.

image
image802×187 4.68 KB

I need the final excel should be like this. Can anyone solve this problem?

2

HI @poojadass.murugadass

How about this expression

(From d In DtBuild.AsEnumerable
Group d By k=d(0).toString.Trim, k2=d(1).toString.Trim Into grp = Group
Let ra = New Object(){k,k2,grp.First()(3)}
Select r = DtClone.Rows.Add(ra)).CopyToDataTable

Check out this XAML file

GroupBy2Columns.xaml (8.6 KB)

image

Regards
Gokul

3

Thank you Gokul. Let me try and update you.

4

Its Working Gokul. Thanks.

Then one more requirement. Like in excel i need the absent days to be added and enter in the required field.

1 Like
5

Hi @poojadass.murugadass

You can try with For each row in data table activity and enter the Absent days in the required field.

Can you create the New topic for this query. Kindly close this topic by mark as solved

It will help for other too.

Regards
Gokul

6

Yeah Sure. Thanks

7

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