Hi, trying to retrieve some data and convert into a matrix table.
This is the data I have in column A and B:
Employee1 --------------01/05/2018 16:30:00
Employee2 --------------01/05/2018 16:31:00
Employee3 -------------- 01/05/2018 16:32:00
Employee1 -------------- 02/05/2018 18:30:00
Employee2 -------------- 02/05/2018 18:31:00
Employee3 -------------- 02/05/2018 18:32:00
Employee1 -------------- 03/05/2018 21:30:00
Employee3 -------------- 03/05/2018 21:32:00
Note: The date and time is in a single cell
Results I want to acheive:
-----------------------01/05/2018-----02/05/2018--------03/05/2018
Employee1 -----------16:30-------------18:30--------------21:30
Employee2 -----------16:31------------ 18:31---------------
Employee3 -----------16:32-------------18:32--------------- 21:32
Appreciate any help in getting this done!
Bookmarks