Help with Sorting rows and columns

[baillieston]

Is there a way that I can achieve this with VBA code or with formula.

I have a sheet with 9 columns
They are headed as follows:

Employee
Task
Min worked Mon dd/mm/yy
Min worked Tue dd/mm/yy
Min worked Wed dd/mm/yy
Min worked Thu dd/mm/yy
Min worked Fri dd/mm/yy
Min worked Sat dd/mm/yy
Min worked Sun dd/mm/yy

Min worked being the minutes worked on a task
rows would look like this

Employee A : Task 1 : 50 : 20: 120:0:0:20:0:
Employee B : Task 3 : 50 : 20: 120:0:0:70:0:
Employee C : Task 5 : 0 : 20: 200:0:0:20:0:
Employee D : Task 1 : 10 : 20: 40:0:0:20:0:


I have hundreds of rows already like this.
My problem is I would like to change the set up to read like this:

Columns would now be named as follows:

Date
Employee
Task
Mins Worked

My example would now look like this:
Mon 14/02/05 : Employee A: Task 1:50
Tue 15/02/05 : Employee A: Task 1:20
Wed 16/02/05 : Employee A: Task 1:120
Thu 17/02/05 : Employee A: Task 1:0
Fri 18/02/05 : Employee A: Task 1:0
Sat 19/02/05 : Employee A: Task 1:20
Sun 20/02/05 : Employee A: Task 1:0
Mon 14/02/05 : Employee B: Task 3:20


Hope this makes sense.
I don't know how to include an example like the ones some people include.

Hope someone can help me here.
Thanks

 

[The Tamer]

Hi Baillieston

It would be a good idea to see an example of what you mean. To post pictures of your spreadsheet, you need to download the HTML maker.

Download it here: www.puremis.net/excel/downloads.shtml
Instructions: www.mrexcel.com/board2/viewtopic.php?t=92622

Good luck

Tamer

 

[baillieston]

Hi Tamer,

I have attempted to use the HTML Maker. Thanks for the advice.
Hear goes ...

This is what my original sheet looks like as I have tried to explain previously.

example for board.xls
	A	B	C	D	E	F	G	H	I	J
1			MinsWorkedontaskeachday
2	Employee	Task	14/02/2005	15/02/2005	16/02/2005	17/02/2005	18/02/2005	19/02/2005	20/02/2005
3	AEmployee	Task1	10	20	0	0	120	30	0
4	BEmployee	Task2	30	0	0	100	0	10	10
5	CEmployee	Task1	10	10	10	10	30	0	0
6	DEmployee	Task3	50	60	0	0	0	0	0
7	DEmployee	Task5	210	0	60	30	30	20	70
Sheet1

What I require help on is how to use some code that will copy the cells elsewhere to look like this format

example for board.xls
	A	B	C	D	E	F	G	H	I	J
1			MinsWorkedontaskeachday
2	Employee	Task	14/02/2005	15/02/2005	16/02/2005	17/02/2005	18/02/2005	19/02/2005	20/02/2005
3	AEmployee	Task1	10	20	0	0	120	30	0
4	BEmployee	Task2	30	0	0	100	0	10	10
5	CEmployee	Task1	10	10	10	10	30	0	0
6	DEmployee	Task3	50	60	0	0	0	0	0
7	DEmployee	Task5	210	0	60	30	30	20	70
Sheet1

I could do this manually but I have hundreds of rows and it is something I have to do often.

Hope someone can help.
Thanks

 

[Norie]

Have you posted the same spreadsheet twice by mistake?

 

[baillieston]

Sorry my 2nd image is the same as the 1st. It should be ( fingers crossed )

example for board.xls
	A	B	C	D	E
14	Date	Employee	Task	MinWorked	blank
15	14/02/2005	AEmployee	Task1	10
16	15/02/2005	AEmployee	Task1	20
17	16/02/2005	AEmployee	Task1	0
18	17/02/2005	AEmployee	Task1	0
19	18/02/2005	AEmployee	Task1	120
20	19/02/2005	AEmployee	Task1	30
21	20/02/2005	AEmployee	Task1	0
22	14/02/2005	BEmployee	Task2	30
23	15/02/2005	BEmployee	Task2	0
24	16/02/2005	BEmployee	Task2	0
25	17/02/2005	BEmployee	Task2	100
26	18/02/2005	BEmployee	Task2	0
27	19/02/2005	BEmployee	Task2	10
28	20/02/2005	BEmployee	Task2	10
Sheet1

 

[Norie]

You might what to edit your posts to remove the

See here <a href ="http://www.mrexcel.com/board2/viewtopic.php?t=131105"> HTML Maker and </a>.

If you do that it will be easier to copy you sample data into Excel so we can help you.

 

[baillieston]

Thanks Norie,

Here goes again.
My original data looks like this.

example for board.xls
	A	B	C	D	E	F	G	H	I	J
1			Mins Worked on task each day
2	Employee	Task	14/02/2005	15/02/2005	16/02/2005	17/02/2005	18/02/2005	19/02/2005	20/02/2005
3	A Employee	Task 1	10	20	0	0	120	30	0
4	B Employee	Task 2	30	0	0	100	0	10	10
5	C Employee	Task 1	10	10	10	10	30	0	0
6	D Employee	Task 3	50	60	0	0	0	0	0
7	D Employee	Task 5	210	0	60	30	30	20	70
Sheet1

I would like help on making it look like this.

example for board.xls
	A	B	C	D	E
14	Date	Employee	Task	Min Worked
15	14/02/2005	A Employee	Task 1	10
16	15/02/2005	A Employee	Task 1	20
17	16/02/2005	A Employee	Task 1	0
18	17/02/2005	A Employee	Task 1	0
19	18/02/2005	A Employee	Task 1	120
20	19/02/2005	A Employee	Task 1	30
21	20/02/2005	A Employee	Task 1	0
22	14/02/2005	B Employee	Task 2	30
23	15/02/2005	B Employee	Task 2	0
24	16/02/2005	B Employee	Task 2	0
25	17/02/2005	B Employee	Task 2	100
26	18/02/2005	B Employee	Task 2	0
27	19/02/2005	B Employee	Task 2	10
28	20/02/2005	B Employee	Task 2	10
Sheet1

Hope this has worked and somone can help.
Thanks