Hello,
I have data on 2 worksheets that I want to merge together to form a single worksheet.
For example, both sheets have a name column, but then one sheet has a salary column and the second sheet has schedule column.
One concern is that the sheets don't have the same names.
Is there a way (with minimal manual intervention/typing) that I can merge these two sheets resulting in a list of names; some with salaries and schedules, then some with just salaries and some with just schedules?
Thank you in advance, Peter