Excel spreadsheet merge -- 2
Budget: $30 – $250 AUD
Hi,
I am looking for an expert in Microsoft Excel who can reconfigure fields in a spreadsheet of 36,000 entries using a formula (not manually).
The list is currently sorted to have an entry with a name, school and then subject. An individual may have multiple subjects that they have completed below their name and school from a separate entry. If they do multiple subjects, I would the subject to be featured in the next field of an entry....For ease of explaining, I have provided a sample of the work in attachments. Please note there are two sheets - 'Before' and 'After'.
Are you able to complete this?
I am looking for an expert in Microsoft Excel who can reconfigure fields in a spreadsheet of 36,000 entries using a formula (not manually).
The list is currently sorted to have an entry with a name, school and then subject. An individual may have multiple subjects that they have completed below their name and school from a separate entry. If they do multiple subjects, I would the subject to be featured in the next field of an entry....For ease of explaining, I have provided a sample of the work in attachments. Please note there are two sheets - 'Before' and 'After'.
Are you able to complete this?