Yes, hacking away. Mix of first name last and last name first. Sent from my iPhone
> On Dec 19, 2021, at 1:11 PM, Bill Prince <[email protected]> wrote: > > > If the data isn't normalized, you are in for a lot of manual labor. > > > > bp > <part15sbs{at}gmail{dot}com> > On 12/19/2021 9:55 AM, Chuck McCown via AF wrote: >> My 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
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
