That is helpful, thanks.
From: Bill Prince Sent: Saturday, December 18, 2021 10:38 AM To: [email protected] Subject: Re: [AFMUG] OT Merging Data I would start with a 4th spreadsheet with all the columns you need (names, addresses, phone numbers, and email addresses). Then the challenge is the merge. Try something like this: https://community.powerbi.com/t5/Desktop/Combine-multiple-excel-files-with-different-structure-columns/td-p/1372702 bp <part15sbs{at}gmail{dot}com>On 12/18/2021 9:02 AM, Chuck McCown via AF wrote: I have at least three files I need to merge. Spreadsheets. Say one has names and addresses One has addresses and phone numbers One has phone numbers and email addresses They are not the same length of file so certain records are missing in all three files. There is something common to allow one file to be merged into at least one of the other files. I really don’t want to write code to parse and search. I am hopeful there is some kind of feature in excel that could do this. Or I guess I might be able to fire up a database and make it happen. Any suggestions? -------------------------------------------------------------------------------- -- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
