Kamranmushtaq
New Member
- Joined
- Sep 17, 2014
- Messages
- 1
| Date | Department | Time | Seconds | Frequency |
| 01-Sep | HR | 0900-1100 | 30 | 2 |
| 01-Sep | HR | 0900-1100 | 60 | 2 |
| 01-Sep | SALES | 1900-2100 | 30 | 3 |
| 01-Sep | SALES | 1900-2100 | 60 | 4 |
| 01-Sep | ADMIN | 2200-2300 | 30 | 2 |
| 01-Sep | ADMIN | 2300-2400 | 60 | 3 |
| 02-Sep | HR | 0900-1100 | 30 | 2 |
| 02-Sep | HR | 0900-1100 | 60 | 1 |
| 02-Sep | SALES | 1900-2100 | 30 | 2 |
| 02-Sep | SALES | 1900-2100 | 60 | 3 |
| 02-Sep | ADMIN | 2200-2300 | 30 | 4 |
| 02-Sep | CS | 2300-2400 | 60 | 5 |
<tbody>
</tbody>
I want to make macro format my data ifrom this format to the below format
| Department | Time | Seconds | 01/09/2014 | 02/09/2014 |
| HR | 0900-1100 | 30 | 1 | 1 |
| HR | 0900-1100 | 30 | 1 | 1 |
| HR | 0900-1100 | 60 | 1 | 1 |
| HR | 0900-1100 | 60 | 1 | |
| SALES | 1900-2100 | 30 | 1 | 1 |
| SALES | 1900-2100 | 30 | 1 | 1 |
| SALES | 1900-2100 | 30 | 1 | |
| SALES | 1900-2100 | 60 | 1 | 1 |
| SALES | 1900-2100 | 60 | 1 | 1 |
| SALES | 1900-2100 | 60 | 1 | 1 |
| SALES | 1900-2100 | 60 | 1 | |
| ADMIN | 2200-2300 | 30 | 1 | 1 |
| ADMIN | 2200-2300 | 30 | 1 | 1 |
| ADMIN | 2200-2300 | 30 | 1 | |
| ADMIN | 2200-2300 | 30 | 1 | |
| CS | 2300-2400 | 60 | 1 | 1 |
| CS | 2300-2400 | 60 | 1 | 1 |
| CS | 2300-2400 | 60 | 1 | 1 |
| CS | 2300-2400 | 60 | 1 | |
| CS | 2300-2400 | 60 | 1 |
<tbody>
</tbody>
It is sample data. number of days vary and also frequency also change
