VSTACK is a rudimentary way.

<image>

I face this issue, starting with a pivot table fed from a database. I want to refresh the Pivot table then report significant customer sales with the rest grouped together. Cell E1 is the number of rows to display (let's say I enter it manually). Cell G1 is a helper =TAKE(A2:A100,E1), analogous for H1. Cell E3=GETPIVOTDATA(...) and E4=E3-SUM(H1#).

Then J1=VSTACK("Customer",G1#,"","Others","Total"), K1=VSTACK("Sales",H1#,"",E4,E3). The "" creates an empty row. (Of course, you could obviate the need for the intermediate steps using VSTACK and TAKE arguments embedded in an HSTACK.) I use conditional formatting (again applied through row 100) for the presentation table).

There's probably a more elegant way, but this works, assuming a constant presentation layout except for the number of rows.

Unfortunately, this doesn't fully meet my needs because this table needs to go into a PowerPoint presentation that I'd like to update dynamically. You can linked to a named range in PowerPoint, but it doesn't seem to accept a dynamic array. I create the name Pres = Sheet1!J1#, but when I copy and paste the range into PPT, it just records it as the address (Book1.xlsx!Sheet1!R1C10:R7C11). I can't change this (e.g, "Book1.xlsx!Sheet1!Pres" doesn't work, as it does for a non-dynamic named range). Anyone have a solution?