Re: [AFMUG] OT Merging DataMy main problem is I don’t have consistent key field data. In one list names may have a middle initial or a middle initial with a period, it is totally missing in other lists or sporadically missing. Ditto addresses. But I am hacking away at it. I have something usable now.
Chuck McCown McCown Technology Corporation 8401 N Commerce Dr Lake Point, Utah 84074 801-250-9503 435-830-4306 cell www.mccowntech.com www.microtrench-blades.com From: Mark - Myakka Technologies Sent: Sunday, December 19, 2021 10:44 AM To: AnimalFarm Microwave Users Group Subject: Re: [AFMUG] OT Merging Data Steve, If KEY fields match between data sets then VLOOKUP is the way to go. I think the new XLOOKUP is an enhanced option of VLOOKUP -- Best regards, Mark mailto:[email protected] Myakka Communications www.Myakka.com ------ Sunday, December 19, 2021, 12:23:28 PM, you wrote: That's what you have to do. I remember I just did multiple pages in one spreadsheet and it was a ton of sort commands and then the merging. I recall it does it all on the clip board and it's real easy to deselect the data for merging. I remember exporting data as csv helped by using notepad++ where I needed random blank cells added to get it in the right format. I dont remember the notepad++ plugin I had to use for that. Excel projects suck. Spend 30 hours learning to master a specific task that takes 2 minutes to perform and you will not remember how to do 2 years later when you need to do it again On Sat, Dec 18, 2021, 11:39 AM Bill Prince <[email protected]> wrote: 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
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
