3) Press Ctrl + E or click the Flash Fill button on the ribbon. Find it by clicking the Data tab, then looking in the Data Tools. 190618-flash-fill-menu. 4) The ...