Lets use Sorting for this.
Sort operation
Select the area for sorting (columns A:E or cells A1:E26), click on the «Sort» button on the «Data» tab, select «Sort by", «Surname», in the window that appears, select the alphabetical sorting order «From A to Z», and click «Ok».
select «Sort by Surname»
Please note: If we wanted to sort the names of Departments in alphabetical order, and then within these departments by Surname, we would first select «Sort by Department», and then add a second level of sorting by clicking on «Add Level» in the upper left corner of the menu, and in the second level that appeared we would select «Surname».
first select «Sort by Department», then by «Surname»
After the sorting is done, the order of the rows with surnames on the «Result» sheet matches the order of the rows on the «Information from HR» sheet.
Note: Sorting (and much more) can also be done using the menu that appears when you right-click. Using the right mouse button to open the menu is a very useful skill that speeds up your work in Excel.
Copy the data from the «Information from HR» sheet to transfer to the «Result» sheet.
Select three columns on the «Information from HR» sheet: «Full name», «Date of employment» and «Date of birth». We dont need the Full name column for the task, but we use it to make sure that the rows with the surnames of employees after sorting now match everywhere.
rows with the surnames of employees after sorting match everywhere
After visual verification that the order of the rows is correct (that is, the last name from column «F» with the full name coincided with the last name from column «C»), the extra column «F» with the Full name must be deleted.
Deleting a column
Select column F by hovering the mouse cursor over the heading F and click the left mouse button. Then click on the right mouse button. In the menu that appears, select «Delete».
select «Delete»
Thus, all the original data has been transferred to the «Result» sheet.
Сreating a new column
Lets create the columns «Experience of full years on the date of the report» and «Age of full years on the date of the report» ourselves.