2 of 2 people found this helpful
Indeed, you need to UNION your sheets, not join them together.
Union puts one set of rows "under" another one.
Join "adds" more columns.
Thank you both! The data was in 2 different workbooks which meant I couldn't create a union. Now the issue is resolved.