View Single Post
 
Old 05-04-2016, 04:39 AM
carlos_cs carlos_cs is offline Windows 10 Office 2013
Novice
 
Join Date: May 2016
Posts: 6
carlos_cs is on a distinguished road
Default 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.
Reply With Quote