![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
selvamariappan | Excel Programming | 1 | 12-12-2011 03:11 AM |