This might be duplicate topic.
Reference :Identify the Duplicates and sum the value
In the above post, there is solution to group by duplicate values and sum but the above solution is removing the non- duplicate values.
Using the above reference topic’s solution I am able to get the group by and sum amount of duplicate values, but it is eliminating the non- duplicate values, Test3 in this case. i need that too.
For duplicate values summation of integer values is perfect but I also need to concat column(0) and column(1) which has string values and concat is not working.
Any help will be very helpful