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… Employe…

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

How to get Multiple column values into a Single Column

Help Studio

Gokul001 (Gokul Balaji) October 10, 2022, 11:55am 4

Hi @Pravin_Mandadi

Check out the XAML file

CombineMultipleCol.xaml (9.2 KB)

Regards
Gokul

1 Like

Topic		Replies	Views
How to merge multiple columns to single column Activities excel , activities , question	10	586	October 11, 2023
Convert single column values into multiple columns Something Else feedback	6	1040	November 27, 2022
How to separate multiple merged data in 1 column into individual columns? Studio studio , question , activities_panel	5	1103	June 28, 2022
Merge multiple rows in one Studio excel , csv , studio , question , activities_panel	17	1177	September 9, 2022
How to convert rows into column? Studio studio , question , activities_panel	4	491	April 25, 2023

How to get Multiple column values into a Single Column

Related topics