Forum Discussion

Anonymous

Not applicable

4 years ago

Merge two rows (having a different cell value) into a single row; overwrite values for text

Hello, I want to merge rows when duplicate "Task" value is found; and overwrite text from one "Response" value to another cellwhen Scaled Value is "-1.00". For example, see below two rows: In...

Anonymous

Not applicable

4 years ago

Hi Anonymous ,

It seems the value"-1" was replaced by "4.00". How can I get the condition? Please provide more data and expected output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable
4 years ago
Hi Anonymous , thanks for your note. Please refer to the dataset in the this Excel as you asked. :https://docs.google.com/spreadsheets/d/1_wL7RtP2pXXJZiKD0U37iOtqKSXETYdp/edit?usp=sharing&ouid=113008550954619586830&rtpof=true&sd=true

Essentially, when there are duplicate Numbers (ex. TKT0536285), I would like the output record with below conditions:
1. those two rows with duplicate Numbers shall be merged into a single row ,and
2. "-1.00" Value of one row's record, shall be replaced with the other value (ex. 4.00) in that merged single row, and
3. the merged record's Reply column shall display text for Ask = Inputs.

For Example, for below duplicate records of the dataset:
Item No. User ID Date Number Ask Reply Value
Survey ABCDE0630219 Hir 2/8/2021 TKT0536285 Inputs It was Ok -1.00
Survey ABCDE0630219 Hir 2/8/2021 TKT0536285 Score Very Satisfied 4.00

The output should be:
Item No. User ID Date Number Ask Reply Value
Survey ABCDE0630219 Hir 2/8/2021 TKT0536285 Inputs It was Ok 4.00

Could you please help?

Thanks in advance!