Excel Formula Needed - Merge Data
Budget: €250 – €750 EUR
Hi,
I need someone who can create an excel formula to merge data.
I have attached the spreadsheet. I want sheet 2 to be referencing all of the data from sheet 1 without having to have any manual inputs. The data in sheet 2 has currently been manually entered. When a name has the same relation number it needs to merge the names and data together in sheet 2.
The spreadsheet must be easily editable (I need to be able to add and edit names without issue) and I need to be able to filter both sides with issue.
Please let me know if you have any questions. I have had a couple of people attempt this unsuccesfuly so please ask any questions if needed and only accept if you are confident you can achieve this.
I need someone who can create an excel formula to merge data.
I have attached the spreadsheet. I want sheet 2 to be referencing all of the data from sheet 1 without having to have any manual inputs. The data in sheet 2 has currently been manually entered. When a name has the same relation number it needs to merge the names and data together in sheet 2.
The spreadsheet must be easily editable (I need to be able to add and edit names without issue) and I need to be able to filter both sides with issue.
Please let me know if you have any questions. I have had a couple of people attempt this unsuccesfuly so please ask any questions if needed and only accept if you are confident you can achieve this.