I need to connect two lists within SharePoint . For example the first list will have a unique id column and a first name column
ID First Name
List 2 will have the same Unique ID column first and last name column. List two will have a workflow that once ran, will pull in the first name and match it to the same ID.
ID Last Name First Name
1 Doe Jacob
2 Smith Jordan
Or I can have a third list that pulls both lists information into it at the same time.
Is this something a workflow can do?