Load the data into Power Query. Once the data is in Power Query, add a column based on the Personnel column as follows: 1. Click the Personnel header to select the column, then click the Add ...