Thank you for these replies. I'm getting much closer to what I need, but I'm still not quite there yet. My issue lies with these line breaks for subtotals. I only care about the individual entries. Manually deleting breaks in order to turn this into a pivot table isn't a long term solution. Thanks to all the other guidance I'm now able to manipulate the columns how I need, but I'm still hung up on these subtotals.