Do you have any software developers on staff? This should be pretty trivial for them.
On Mon, Dec 20, 2021 at 1:53 AM Ryan Ray <[email protected]> wrote: > regex and xlookup solves your issue > > On Mon, Dec 20, 2021 at 1:41 AM Forrest Christian (List Account) < > [email protected]> wrote: > >> 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 >> >
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
