Excel Consolidate Data not working - Data does not merge

0 votes

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.

Nov 17 in Others by Kithuzzz
• 20,660 points
24 views

1 answer to this question.

0 votes

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: enter image description here

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.

answered Nov 17 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

'Microsoft.Office.Interop.Excel.Range' does not contain a definition for 'get_Default'

You are using C# version 4, the ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
139 views
0 votes
1 answer

Word Mail Merge with Excel data has to be saved in different files with custom names

Try this: Public Sub Mail_Merge() On Error GoTo ErrH Dim ...READ MORE

answered Nov 6 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

Excel does not show hidden sheet but if i unzip it, then there are 2 worksheets

I now know that an Excel worksheet ...READ MORE

answered Nov 12 in Others by narikkadan
• 37,660 points
28 views
0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
22 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
449 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
394 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,365 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,816 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
43 views
0 votes
1 answer

Force download excel file not working on web server

Change the content type to Content-Type: application/vnd.ms-excel Or try ...READ MORE

answered Oct 11 in Others by narikkadan
• 37,660 points
63 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP