SOLVED
Home

How to group rows of data with text

Kacie_1260
New Contributor

I am exporting a report that lists multiple employee names in column "B", column "C" is the payroll item (example: Hourly, Overtime, Double Time, A-Foreman, B-Foreman, etc.) and column "D" is the hours worked.  I want the columns to consolidate per Employee name in column "B" then by payroll item in column "C" and finally the total hours worked in column "D".  This would result in the same employee name consolidating into potentially multiple payroll codes.  I cannot seem to figure out how to get the payroll items to show up.  Maybe I am not thinking of the correct function that would work best for this scenario?  Below is an example of what I have for data layout and what I would like to see.

 

What the report provides:

Column B           Column C           Column D

Employee 1          Hourly                  5

Employee 2          Overtime              2

Employee 1          A-Foreman           1

Employee 2          Overtime               2

Employee 1          Hourly                   1

 

 

What I want to see:

Column B           Column C           Column D

Employee 1           Hourly                 6

Employee 1           A-Foreman          1

Employee 2           Overtime              4

 

I appreciate any help I may get!

5 Replies
Highlighted
Use SUMIFS.
Solution

Hi @Kacie_1260 ,

 

If you have ton of entry's. then use pivot table.

Pivot table.JPG

Fastest and Easiest way. 

If you need more clarification, Pls let me know.

 

Best regards

Naveen

Thank you very much Naveen!  That was an incredibly easy step to sort my data (50,000+ hours to sort).  I cannot thank you enough for your help.  This is going to save me hours of work!!

 

I hope you have a wonderful day!

Kacie

Thank you, Twifoo.  I will be using this function in some of my steps!  I hope you have a great day.

Hi, @Kacie_1260 ,

 

Glad to help you.

 

Regards,

Naveen

 

Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies