Excel MS Query, is it possible disable query result to show only one row if ....

[karmapala]

I have a data where there are two rows which has exactly the same value in each column.
For example the data source like this :
Row 1 : Col-A : A01, Col-B : 123, Col-C : January, Col-D : 5 kg, Col-E : Fish
Row 2 : Col-A : A01, Col-B : 123, Col-C : January, Col-D : 5 kg, Col-E : Fish

However after the resulted query is only one of the row.

I know within the data source I can just change the kilos to 10 kg in one row, then delete the other row.
But this give me a problem, because there are quite many of that kind of situation (different row but has the same value in each column).

How come the data is like that (two rows with the exact same value in each column) is difficult for me to explain,
as this is another people who input it to the data source whom I don't know why, he prefer to write it for the second time in a new row
rather than change the kilos to 10kg to the existing row.

I'm hoping that there is a thing I can do, in order the MS Query result will not remove the duplicate row, but include the row as it is.
So, I wonder is this possible ?

Any kind of help would be greatly appreciated.
Thank you in advanced.

[5631]

It depends on your query in MS Query. What is the text?

[karmapala]

It depends on your query in MS Query. What is the text?

Do you mean the text like this ?

Please Login or Register  to view this content.

And in the connection properties, the connection is like this :

Please Login or Register  to view this content.

Thank you.

[5631]

I mean Select command. It can include group by expression to exclude duplicate records.