DUPLICATE VALUES, COMBINED TABLE, HELP!

Buenos friends days

First of all thank you very much for your time, attention and usual support, I value and appreciate it very much, you help me to improve and I appreciate it.

I have a problem with a table, I am making a report with a search engine, that is, search engine by number of TX I of information of the same, for this combine queries and I could have all the information in a single table, however this ocaciona that the values are not correct since it duplicates them, when trying to remove the duplicity it eliminates them and gives me the real value of the column that I want, however when removing those of that column I also remove those of the other affecting the amount. I add images to be more explanatory

As you can see effectively the same TX appears in element 1 and 2, however the identifiers are repeated I assume that it does to complete space the program, I could have a distinctive count and I would effectively give the number of real elements however this would affect me for the capacity, since as we see the capacity of element 1 is repeated since it is really only 1 capacity per identifier element 1 ,

REMOVING THE DUPLICATE ELEMENTS by removing the duplicate elements from the identifier element 1 effectively gives me the real value of the capacity of element 1 and the duplicates are eliminated, this will give me a real power in the report, however it affects me the "IDENTIFIER ELEMENT 2" since it makes it only remain with a single digit, 156745, as you will see in previous were several, and this affects me in the report since it does not give me a way to really show how much element 2 exists in the TX searched,

I would appreciate if anyone can contribute to me with a solution,

Something like this would be the search engine, the ideal is that when looking for the TX indicate the CAPACITY OF ELEMENT 1, number of elements 1, amount of elements 2.