Simple consolidation by date

[leebauman]

Hello, I want to convert this:
Excel 2016 (Windows) 32 bit
[Table="width:, class:head"]
[tr=bgcolor:rgb(255, 255, 255)][td]

Name​

[/td][td]

Date​

[/td][td]

Hours​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Bob[/td][td]

1/1/2017​

[/td][td]

4.5​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Bob[/td][td]

1/1/2017​

[/td][td]

3.5​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Bob[/td][td]

1/2/2017​

[/td][td]

4.5​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Bob[/td][td]

1/2/2017​

[/td][td]

5​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Mary[/td][td]

1/1/2017​

[/td][td]

3.5​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Mary[/td][td]

1/1/2017​

[/td][td]

3​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Mary[/td][td]

1/2/2017​

[/td][td]

6​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Mary[/td][td]

1/2/2017​

[/td][td]

2.5​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

to this:
Excel 2016 (Windows) 32 bit
[Table="width:, class:head"]
[tr=bgcolor:rgb(255, 255, 255)][td]

Name​

[/td][td]

Date​

[/td][td]

Hours​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Bob[/td][td]

1/1/2017​

[/td][td]

8​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Bob[/td][td]

1/2/2017​

[/td][td]

9.5​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Mary[/td][td]

1/1/2017​

[/td][td]

6.5​

[/td][/tr]

[tr=bgcolor:rgb(255, 255, 255)][td]Mary[/td][td]

1/2/2017​

[/td][td]

8.5​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[AFPathfinder]

You're looking to summarize your table, then, right? Maybe a pivot table?

 

[leebauman]

I'm looking to build a new table which I can pivot off. If I pivot off the existing data, it gives me headers by Name which makes it difficult to look at totals by date (my data set is very large...years of dates and name). Thanks.

 

[AFPathfinder]

I'd say VBA or run the advanced filter the first two columns (no criteria, check unique) and use a SUMIFS formula to populate the totals for the third column.

 

[leebauman]

Terrific. I'll give it a shot. Thanks for the suggestion.