Excel – using Flash Fill
Flash Fill is one of the most sensational features of Excel. Besides being very easy to use, it brings us incredible productivity. It is a relatively old feature (Excel 2013), but I only discovered it about 2 years ago, and since then, I have used it for several situations. It is possible that you don't know about it either, but after this topic, you will have a greater appreciation for Excel.
Let's imagine that I am publishing an article where I must fill in all the bibliographic references of books I used. The references have a pattern, and I only have the complete information, but they are not standardized. Normally, a referencing style pattern is LASTNAME, Name. Book Name (Year).
I have built a spreadsheet with a list of books, as shown in Figure 15.16. For brevity's sake, I have only used a few books in this example, but in a published article, numerous references would probably be used: