Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 12:34 PM.


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