We are working on a data migration job for a client and require the assistance of an Excel expert to assist in gathering data.
The Excel spreadsheet contains many tables that were extracted from a SQL database. Formulas in the sheet will gather data and reorder it to the new database format for later import.
An example of this is as follows:
ClientID in AA1, Name in AB1, Birth Date in AC1
A reference ID is located in A1
Cell B1 will be compiled using the following formula.
To give the result: John Smith|01-10-2015|1
The problem we need assistance with is that the ID will only be returned once by VLOOKUP when it may appear multiple times in the column.
We need all results returned in the cell, like so:
And so on.