You already have a room list and a chair inventory in the same order. HSTACK can put them side by side for a quick printout. The function uses row position, so confirm the two lists really do line up.

Compare the IDs before stacking

In B2:C3, use R-01, Cedar and R-02, Birch. In F2:G3, use R-01, 12 and R-02, 18. Check that the first and last IDs match and that both ranges cover the same rows.

Both source ranges begin with R-01 and end with R-02.

Illustrated sources. Check the row identifiers in both ranges before stacking.

In an empty area of a compatible spreadsheet, enter:

=HSTACK(B2:C3,F2:G3)

Read the result across

The first row should show R-01 twice and Cedar with 12 chairs. The second should show R-02 twice and Birch with 18. If either list was sorted differently, use a keyed lookup or realign the lists before stacking. Keep both ID columns visible until the check passes.

The four-column output shows R-01, Cedar, R-01, 12 on the first row and R-02, Birch, R-02, 18 on the second.

Illustrated stacked result. Keep the duplicate IDs visible while checking alignment.

Microsoft’s Excel function reference