How to Create a PivotTable from Groups of Rows in Excel

 I'm going to post something a little different today.  I came across a challenge at work a few days ago that got me thinking about Excel.

So say you have a bunch of data that looks like this:

How would you organize this data so that rather than looking at 30+ lines of data, you only have to look at 4 lines to determine how many hours each division worked at each job?  If you try to create a pivot table from this data, you get this:

Well, that doesn't help.  We have how many hours each division worked, but the jobs are completely separate.  So how do we organize this by groups rather than by row/column?  It looks like the solution lies in some sort of if/and/vlookup function/formula.  But I don't have much time today, I'll look into this more later.  If you have an idea of how to solve this, let me know!

Happy Saint Patty's Day!

I hope you're all wearing green today.  Or perhaps you're green with envy?  Apparently parts of that expression can be traced all the way back to the ancient Greeks. Back then, the color green was associated with paleness, fear, illness, and poor humor.  I guess overtime people started associating it with other frowned-upon emotions like envy?  Thanks for coming to my Ted Talk.  Happy Saint Patrick's Day Errybody

WHOA HEY I'M BACK AGAIN

Hi. Long time to talk. I'm back from the dead to talk about the Steam Deck.

This thing looks supes cool, but even though I reserved mine within two hours of pre-orders becoming available, I won't be getting mine til Q3 of this year :( I've been doing a lot of research on the Deck and I have one question that I've yet to find an answer to: Can it run a virtual machine? Obviously there aren't any virtual machine apps within Steam, but what about Desktop mode?

It's just Linux, right? There are virtual machines on Linux. I know there are a lot of Windows Games that the Steam Deck can't currently run, but what if some older games were playable inside of a virtual machine on the Deck? It could open a new world of possibilities. If anyone's still here, let me know your thoughts or if this is even possible. I'm getting excited thinking about it.

Quick update: From what I've read, it looks like it should be possible, but it wouldn't be able to access the GPU.  That shouldn't be too much of a problem for older games that don't use many resources, right?  I just want a portable retro pc in the palm of my hands (not a laptop).  I have the original GPD Win but it's so slow.

The Next Animal Crossing Game

Just Claus 2 - Content Free Time