Excel Consolidate Data not working - Data does not merge

Question

I can't seem to make the Excel consolidation function work for some reason. My data won't combine.
My column contains just numbers that are structured as dollar amounts.

My original data set looks like this:

__________________
|NAME    |DOLLARS |
|Andrew  |  $10.00|
|Michael |  $10.00|
|Emma    |  $10.00|
|Andrew  |  $10.00|
|Michael |  $10.00|
|Emma    |  $10.00|
-------------------

However, when I run it through the Consolidate Data function, making sure to select all of the data as well as the headers, I get the following output:

__________________
|NAME    |DOLLARS |
|        |  $10.00|
|        |  $10.00|
|        |  $10.00|
|        |  $10.00|
|        |  $10.00|
|        |  $10.00|
-------------------

I'm not sure why it's not functioning. I tried meticulously according to a number of tutorials and searching the internet for solutions, but nothing I tried worked.

Answer 1

This is so that letters cannot be consolidated by simply adding them together. As this would be an error, it leaves them blank. You must indicate that the first column is just to be utilized as row labels rather than being summed. Ticking achieves this.

Use labels in > Left column

You have already selected the Top row. it is the option underneath: 

This does result in no column name for the first column, but you could easily type that back in afterward in the destination range.

I hope this helps you.