Sounds like a great project to learn python on.
On Sun, Dec 19, 2021, 1:18 PM Chuck McCown via AF <[email protected]> wrote: > 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 >
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
