Hello everyone,
I'm new here so I hope my post is according to the rules.
I have an excel sheet that looks something lie this:
date date date date
10:00 10:00 10:00 10:00
ms.*** name name name
ms.*** name name name
ms.*** name name name
date date date date
13:00 13:00 13:00 13:00
ms.*** name name name
ms.*** name name name
ms.*** name name name
The file is attached.
Each name is written 8 times in different date and hour.
I would like to find a quick way to get a list (preferrably a text file) that will contain the dates and hours for each person individually.
for example:
miss nelly
22/7 10:00
25/7 15:30
3/8 15:30
5/8 15:30
11/8 10:00
and three more.
any ideas? any help will be much appreciated.
I'm new here so I hope my post is according to the rules.
I have an excel sheet that looks something lie this:
date date date date
10:00 10:00 10:00 10:00
ms.*** name name name
ms.*** name name name
ms.*** name name name
date date date date
13:00 13:00 13:00 13:00
ms.*** name name name
ms.*** name name name
ms.*** name name name
The file is attached.
Each name is written 8 times in different date and hour.
I would like to find a quick way to get a list (preferrably a text file) that will contain the dates and hours for each person individually.
for example:
miss nelly
22/7 10:00
25/7 15:30
3/8 15:30
5/8 15:30
11/8 10:00
and three more.
any ideas? any help will be much appreciated.