Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2016, 04:39 AM
carlos_cs carlos_cs is offline Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Windows 10 Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Office 2013
Novice
Automatically Organize data in a sheet differently (in order to create a dynamically updated graph)
 
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
  #2  
Old 05-04-2016, 05:46 AM
gebobs gebobs is offline Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Windows 7 64bit Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 05-04-2016, 05:57 AM
gebobs gebobs is offline Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Windows 7 64bit Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

A simple pivot table might work.
Attached Files
File Type: xlsx time.xlsx (13.0 KB, 9 views)
Reply With Quote
  #4  
Old 05-04-2016, 08:44 AM
carlos_cs carlos_cs is offline Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Windows 10 Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) Office 2013
Novice
Automatically Organize data in a sheet differently (in order to create a dynamically updated graph)
 
Join Date: May 2016
Posts: 6
carlos_cs is on a distinguished road
Default

thank you for the solution!
Reply With Quote
Reply

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
Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) 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
Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) How to create an Excel add in that will automatically build tables from data selvamariappan Excel Programming 1 12-12-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft