In Libre Office Calc (or Excel) What formula to use (in sheet 3) in order to combine data of sheet 1 and 2 based on the ID column?
Get the last name and style from sheet 2 based on ID column
Sheet 1
╔═════╦═══════╗
║ ID ║ First ║
╠═════╬═══════╣
║ aaa ║ bob ║
║ aaa ║ bob ║
║ aaa ║ bob ║
║ bbb ║ james ║
║ bbb ║ james ║
║ ccc ║ mary ║
╚═════╩═══════╝
Sheet 2
╔═════╦════════╦════════╗
║ ID ║ Last ║ Style ║
╠═════╬════════╬════════╣
║ aaa ║ Marley ║ Reggae ║
║ bbb ║ Brown ║ Funk ║
║ ccc ║ Hopkin ║ Folk ║
╚═════╩════════╩════════╝
Sheet 3 - Results
╔═════╦═══════╦══════╦═══════╗
║ ID ║ First ║ Last ║ Style ║
╠═════╬═══════╬══════╬═══════╣
║ aaa ║ bob ║ ║ ║
║ aaa ║ bob ║ ║ ║
║ aaa ║ bob ║ ║ ║
║ bbb ║ james ║ ║ ║
║ bbb ║ james ║ ║ ║
║ ccc ║ mary ║ ║ ║
╚═════╩═══════╩══════╩═══════╝