Group by issue

Hi, I have been working on this forever and I cannot seem to get it to work.  For my project I need both current year and prior year values in the same row.  They come from 2 documents so I have them as two queries.  I combined them by I appending the prior year's values to the current year's.  However, for the if there is a balance for an account for both years, it gives me two rows rather than one which causes problems later in my analysis.  I cannot figure out how to do this, I had assumed it was as easy as a group by like this:

However that did not work.

Here is my output:

I would like there to be one 1000-1010 row, with values for both the current year and past year balances.  Any help or tips would be much appreciated!