How to get Multiple column values into a Single Column

Help Studio
, , ,
1

Hello All…

I have an Excel sheet as shown below…

Employee ID IT-Department Finance-Department HR-Department Accounts-Department
E-0001 Finance
E-0002 IT
E-0003 Accounts
E-0004 HR

I want to get the above Multiple columns into a Single column as shown below…

Employee ID Department
E-0001 Finance
E-0002 IT
E-0003 Accounts
E-0004 HR
Can any one please help me on this…
Thanks in Advance

Regards,
Pravin.

2

DT1=(From r in DT.asenumerable
Select DT1.Rows.add({r(0),String.Join(“”,r.itemarray.Skip(1).Toarray)})).Copytodatatable

1 Like
3
  1. read range
  2. add column name "departement "
    3.for each row in dt
  3. row(“departement”)= row(“it_departement”).tostring+row(“finance_departement”).tostring+…
  4. delete column it_departement/finane_departement if you want
    6.write range
1 Like
4

Hi @Pravin_Mandadi

Check out the XAML file

CombineMultipleCol.xaml (9.2 KB)

Regards
Gokul

1 Like
5

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