u/GeekgirlOtt

teat me as a beginning beginner pre-beginner level user

4 columns - uniqueid, email, name, company

I will export to CSV and can import only the first 3 into the program.

Before exporting, within Excel, how would you attack this :

Where name is missing, populate it with the company if it exists

uniqueid,name,email,company
00011,CindyLou Who,cwho@company.tld,
00012,,grinch@company2.tld,Grinchdom
00013,,sally@company3.tld,
00014,Patrick,pat@spongebob.tld,Spongey
00015,,bob@spongebob.tld,Spongey

desired:

uniqueid,name,email
00011,CindyLou Who,cwho@company.tld
00012,Grinchdom,grinch@company2.tld
00013,,sally@company3.tld
00014,Patrick,pat@spongebob.tld
00015,Spongey,bob@spongebob.tld

Was setting up a newly unboxed Dell laptop with ethernet MAC beginning 48:21:0B and it shows up as an Asus NUC 14 Pro - that's pretty darn specific, but alas incorrect. And yes, I've since confirmed there is no rogue device here mimicking the Dell's MAC and hostname. That OUI is Pegatron - a third party provider known to supply Apple, Dell, and I'm guessing Asus too.

How does it attempt to determine manufacturer and model ? Is there a process to report false info ?

(UDR (original) if it makes a difference)