Hi, I want to read rows and create a new column as per Column C’s value (e.g. Paid, Not Paid) and add the value in a single row for the same Emp_ID. I’ve attached my Input sheet and I want the data like the Output screenshot. Input: [image] Output: [image] Thanks in advance.

Create column as per Column's value and add data for same Employee in single row

Hiba_B (Hiba Beldi) August 29, 2021, 7:14pm 3

Hi @RohitK !
Sure, here is a suggestion: Paid_or_not_paid.xaml (7.0 KB)

Let us know if it does not work as expected or if the code needs more explanation

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
How to add only a particular column using LINQ Studio excel , activities , question	5	730	July 28, 2023
How to Append a column in this situvation Help studio , question	10	873	December 24, 2020
Add data column to datatable and set same value to every row Help	12	17600	November 15, 2018
Need to add new column in for each row Help excel , activities , question	13	2503	January 10, 2021
Based on two column value we need concatenate remain column value Studio datatable , excel , studio , question , activities_panel	15	340	December 31, 2023