=CONCAT(A2, " - ", B2)

| Goal | Best Tool | | :--- | :--- | | | XLOOKUP (or VLOOKUP) | | Stack lists vertically | Power Query (Data Tab) | | Join text strings | & operator or TEXTJOIN | | Make a pretty header | Merge & Center |