Last updated: $8/3/2023$ Using FlashFill: Using Excel to sense patterns in your data

Ctrl E$,$ right click Flashfill

With Flashfil, you are "teaching Excel" how to sense a pattern so if one example does not work, use multiple examples.

Remember that in the real world, your data file may have $1000\text{'}$s of rows. This is a huge timesaver!!

Table $1$

$\backslash$table$[[$Employee Name,Last Name,First Name$],[$Tanner$,$ Timothy $($Sales$),,,$Department$],[$Taylor$,$ Hector $($Sales$),,,],[$Weber$,$ Larry $($ADC$),,,],[$White$,$ Dan $($Admin$),,,],[$Wiggins$,$ Amy $($Training$),,,],[$Wilkins$,$ Sandy $($Marketing$),,,],[$Holland$,$ Don $($Training$),,,],[$Page$,$ Lisa $($Sales$),,,],[$Pratt$,$ Erik $($Sales$),,,],[$Spencer$,$ Boyd $($Marketing$),,,],[$Andrews$,$ William $($Training$),,,],[$Brown$,$ Betty $($Admin$),,,],[$Carson$,$ Catherine $($Training$),,,],[$Carlton$,$ James $($Sales$),,,],[$Chase$,$ Troy $($Training$),,,],[$Dawson$,$ Jonathan $($Admin$),,,]]$

Instructions:

Table $1$: Using Excel Flashfill create the following columns of

information:

Last Name

First Name

Department $q,$

$\backslash$table$[[$Employee Name,First Name,Last Name,email,initials$],[$Tanner$,$ Timothy,,,,$],[$Taylor$,$ Hector,,,,$],[$Weber$,$ Larry,,,,$],[$White$,$ Dan,,,,$],[$Wiggins$,$ Amy,,,,$],[$Wilkins$,$ Sandy,,,,$],[$Holland$,$ Don,,,,$],[$Page$,$ Lisa,,,,$],[$Pratt$,$ Erik,,,,$],[$Spencer$,$ Boyd,,,,$],[$Andrews$,$ William,,,,$],[$Brown$,$ Betty,,,,$],[$Carson$,$ Catherine,,,,$],[$Cariton$,$ James,,,,$],[$Chase$,$ Troy,,,,$],[$Dawson$,$ Jonathan,,,,$]]$

Table $2$: Using Excel Flashfill create the following columns of information: $1.$ Last Name

$3.$ email for everyone by attaching FirstName.Last

Name@memphis.edu

Table $3$

Employee Name

Grades

Using Flashfill Table $3$: Using Excel Flashfill create the following columns of

information:

$1.$Fix Caps e$.$g Andrews, William

Table $4$: Using Excel Flashfill create the following columns of

information:

$1.$Extract the Product Type $-$ middle part of the Product Code

Extract the Year of transaction into a separate column