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
