|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically Organize data in a sheet differently (in order to create a dynamically updated graph)
I currently have this in sheet1 columns A,B,C:
Date Time Worker 04/04/2016 4,5 John 05/04/2016 2 John 06/04/2016 6,5 John 07/04/2016 0 -- 08/04/2016 0,5 Charles 08/04/2016 2 John 08/04/2016 0,5 William 09/04/2016 0 -- 10/04/2016 0 -- 11/04/2016 9 John 11/04/2016 3,75 William I want this in sheet2 columns A,B,C,D (or more in case of more names): Date Charles John William 04/04/2016 0 4,5 0 05/04/2016 0 2 0 06/04/2016 0 6,5 0 07/04/2016 0 0 0 08/04/2016 0,5 2 0,5 09/04/2016 0 0 0 10/04/2016 0 0 0 11/04/2016 0 9 3,75 I need this because I need to make a graph and data has to be organised like this or I'm not able to create the graph! The code (which i believe it's the only way) has to work with any given dates, times or worker names! Worker names in alphabetical order if you can. I don't have any clue how to code this and it is giving me nightmares for weeks. Really need all the help for this one. |
#2
|
|||
|
|||
Will there ever be dates when two employees worked i.e. two rows with the same date?
Edit...nevermind. See that there are. Crap. The way I was thinking won't work. |
#3
|
|||
|
|||
A simple pivot table might work.
|
#4
|
|||
|
|||
thank you for the solution!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to insert a straight table into PPT where the values are dynamically updated? | Officer_Bierschnitt | PowerPoint | 1 | 01-14-2016 10:34 AM |
Automatical email when sheet is updated? | TB12 | Excel | 3 | 06-24-2014 09:00 AM |
How to copy data automatically to particular sheet? | nicholes | Excel Programming | 13 | 03-12-2014 01:05 AM |
How to create a column graph from row data in excel | jyfuller | Excel | 0 | 07-02-2013 05:07 AM |
How to create an Excel add in that will automatically build tables from data | selvamariappan | Excel Programming | 1 | 12-12-2011 03:11 AM |