Sure, I can help you with that. Here's how you can combine rows and sum data with the same ID in Microsoft Excel:

1. First, select the entire data range that you want to work with, including the column headers.
2. Next, go to the Data tab in the ribbon and click on Remove Duplicates. In the pop-up window, make sure that only the Account ID column is selected and click OK. This will remove all duplicate rows based on the Account ID column.
3. Now, you need to sum up the amounts for each unique Account ID. To do this, you can use the SUMIF function. In a new column next to the Amount column, enter the formula
   Formula:

   "=SUMIF(A:A,A2,B:B)" 

   (assuming that the Account ID column is column A and the Amount column is column B). This formula will sum up all the amounts in column B that have the same Account ID as the current row.
4. Copy the formula down to all the rows in the new column. You should now have a new column with the total amount for each unique Account ID.
5. Finally, you can delete the original Amount column if you no longer need it.

That's it! You should now have a table with one row per unique Account ID and the total amount for each account. Let me know if you have any questions or if there's anything else I can help you with.