Column D Data to Row

S

Steved

Hello from Steved
A B C D
1-Aug-03 Fri City 39540
1-Aug-03 Fri Rosk 37101
1-Aug-03 Fri Papa 7721
1-Aug-03 Fri Wiri 24517
1-Aug-03 Fri Shore 20886
1-Aug-03 Fri Orewa 4695
1-Aug-03 Fri Swan 20396
2-Aug-03 Sat City 15664
2-Aug-03 Sat Rosk 16585
2-Aug-03 Sat Papa 2986
2-Aug-03 Sat Wiri 8027
2-Aug-03 Sat Shore 7080
2-Aug-03 Sat Orewa 1188
2-Aug-03 Sat Swan 6879
3-Aug-03 Sun City 11180
3-Aug-03 Sun Rosk 8023
3-Aug-03 Sun Papa 1517
3-Aug-03 Sun Wiri 4171
3-Aug-03 Sun Shore 4115
3-Aug-03 Sun Orewa 1018
3-Aug-03 Sun Swan 4036
4-Aug-03 Mon City 37796
4-Aug-03 Mon Rosk 33360
4-Aug-03 Mon Papa 6551
4-Aug-03 Mon Wiri 23392
4-Aug-03 Mon Shore 21011
4-Aug-03 Mon Orewa 4794
4-Aug-03 Mon Swan 18832
I would like to Automate 3 rows of 7 (M-F, Sat, Sun)only
using the information in Column D. Please look at 1-Aug-
2003, which is a Friday, so when I change to 1-Sep-2003 it
falls on a Monday. The above information is a sample of a
whole Month. Yes I've tried TRANSPOSE but when the month
changes the information is in the wrong below is an example
as what I need

Col Col
H1 39540 I1 37796
H2 37101 I2 33360
H3 7721 I3 6551
H4 24517 I4 23392
H5 20886 I5 21011
H6 4695 I6 4794
H7 20396 I7 18832

H9 40313
H10 35722
H11 7358
H12 25067
H13 21030
H14 5004
H15 19866

H17 40371
H18 35597
H19 8316
H20 26669
H21 21124
H22 4887
H23 20376

Thankyou
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide column difficulty 3
sumif column of month are the same 7
Countif between Time stamps and have - value 0
The Tueday prior to a holiday... 8
Cross Reference Vertical and Horizontal for Data 4
Number of hrs worked in a week, based on dates in a different column 1
Help to Highlight Excel Row based on Weekly Date Range 2
How to calculate worked weekend days 3

Top