I am trying to recreate an old ASP member directory and put it into a Wordpress plugin (Ultimate Member) and need to change the data structure before importing.
I exported the old data into a CSV/Excel file that has a couple tables(sheets):
Member info table containing 4,000 members (each has a Firm ID field (a number i.e. 344); multiple members can belong to a Firm)
Firm table with 1,000 firms (first field is Firm ID)
In the old app the Firm ID number in the Member table calls up all of the fields from the Firm table. I need this to be all in one table to import. If I did this manually I would have to look at the Firm ID number for all 4,000 members and then paste in that firms fields from the Firm table into the Member table. Is there an easier way to do it?
If I understand correctly, you have a column A with all members, a column B with all IDs and you need a column C with the names if the firms.
If your firm list is in the same document in a second sheet (let's say 'Sheet2', you can type in cell C2:
=vlookup(B2;Sheet2!A:B;2;FALSE)
Then just drag the cell down (double click on the bottom right corner)
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments