Import the tab-delimited BlueLake_Project2.txt file using the From Text (Legacy)

Import the tab-delimited BlueLake_Project2.txt file using the From Text (Legacy) command in to cell A19 in Sheet1. The imported data repositions the existing data (Figure 1).FIGURE 1 IMPORTED TEXT FILE
Select cells A19:C32 and copy them to the Clipboard.
Select D19 and open the Paste gallery [Home tab, Clipboard group]. Choose Paste to insert the data without formatting.
Press ESC to cancel the moving border. Close the Queries and Connections pane.