Can you provide an example of how you would like the data to look like so we can better understand what you are asking?

If you sort the data as is, the result you and we are getting is correct. However it seems that you want to get rid of certain entries?

Note that for a number of the Field 1 entries, the Field 2 and 3 entries are meant to be the same. I.e. certain companies are run by the same organization.