Dundee Lad
Active Member
- Joined
- Sep 6, 2003
- Messages
- 311
Hi folks can you please help. I have searched the board but have not founf the answer i need. I have a workbook (sample data below)
and I need to get it into the format below.(there are on average 3000 rows with 5 columns)
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | UIN | NAME | 22/03/2006 | 29/03/2006 | 05/04/2006 | 12/04/2006 | 19/04/2006 | ||
2 | 3WSEDR | SAQ | 3 | 3 | 1 | ||||
3 | 2WDFRT | WSA | 11 | 23 | 1 | 3 | |||
Sheet1 |
and I need to get it into the format below.(there are on average 3000 rows with 5 columns)
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | UIN | NAME | WEEKENDING | HOURS | ||
2 | 3WSEDR | SAQ | 22/03/2006 | 3 | ||
3 | 3WSEDR | SAQ | 05/04/2006 | 3 | ||
4 | 3WSEDR | SAQ | 19/04/2006 | 1 | ||
5 | 2WDFRT | WSA | 29/03/2006 | 11 | ||
6 | 2WDFRT | WSA | 05/04/2006 | 23 | ||
7 | 2WDFRT | WSA | 12/04/2006 | 1 | ||
8 | 2WDFRT | WSA | 19/04/2006 | 3 | ||
Sheet2 |