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.

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.

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



