How can I have column E copy its data into the right column based on the initials in column M?

Question

So what I have so far is a spreadsheet that will auto time stamp column N when my technicians enter their initials into column M.

Now the 2nd thing I would like the spreadsheet to do is.

When I enter the hours (example: 1.8) into column E "HRS." And have the spreadsheet put the HRS. into the correct Technicians column. Based on the initials entered in column M "Tech Up".

Example: if E4=1.8 it would put 1.8 into G4 because M4=AB
Example: if E6=3.2 it would put 3.2 into J6 because M6=JW

I have a screenshot could paste, but I'm a new user to the site. Thanks for the help.

Answer 1

Something like this? The ranges are different here but the logic is the same - each cell in your range gets a formula like this (this is cell B2 in the screenshot):

=IF($E2=B$1,$A2,"")

Which checks to see if the value in the Name column is equal to the column heading of the current cell; if so, it adds the value you put in the HRS column, and if not, it stays blank.