The first way, drag the first entry until the end. Now, click theAUTOFILL option in exceland select “Flash Fill”.Consequently, it will insert all the FY years ...
Flash Fill in Excel - How To Use? Shortcut, Examples & Templates.
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.