Title: 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
