Forum Discussion
Merge two rows (having a different cell value) into a single row; overwrite values for text
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.
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!