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, 2022 in Others by Kithuzzz
• 38,000 points
1,986 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, 2022 by narikkadan
• 63,600 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, 2022 in Others by narikkadan
• 63,600 points
2,235 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, 2022 in Others by narikkadan
• 63,600 points
1,799 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, 2022 in Others by narikkadan
• 63,600 points
510 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, 2022 in Others by narikkadan
• 63,600 points
906 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,740 points
1,243 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,020 points
1,104 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,020 points
4,389 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
4,275 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, 2022 in Others by narikkadan
• 63,600 points
784 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, 2022 in Others by narikkadan
• 63,600 points
2,288 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