how match many column times with many value columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2978323%22%20slang%3D%22en-US%22%3Ehow%20match%20many%20column%20times%20with%20many%20value%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2978323%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%203%20time%20columns%20and%203%20number%20columns%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20do%20i%20get%20all%20of%20the%20date%20and%20times%20to%20match%20for%20every%20result%3C%2FP%3E%3CP%3Emy%20only%20way%20has%20to%20been%20to%20click%20and%20drag%3C%2FP%3E%3CP%3Ei%20need%20all%20this%20to%20matchup%20so%20i%20can%20graph%20it%20properly%3C%2FP%3E%3CP%3Eeven%20if%20all%20the%20times%20dont%20matchup%20i%20at%20least%20could%20use%20the%20days%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2978323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2978997%22%20slang%3D%22en-US%22%3ERe%3A%20how%20match%20many%20column%20times%20with%20many%20value%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2978997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1140234%22%20target%3D%22_blank%22%3E%40dattmuffy%3C%2FA%3E%26nbsp%3BPlease%20clarify%20your%20intentions.%20For%20instance%2C%20Col%20A%20and%20C%2C%20both%20have%20three%20entries%20for%20the%2016th%20of%20November%20with%20time%20and%20one%20without%2C%20whereas%20column%20E%20has%20only%20one%20single%20item%20for%20the%20day%20without%20time.%20Would%20you%20want%20to%20sum%20the%20values%20by%20day%20only%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3006745%22%20slang%3D%22en-US%22%3ERe%3A%20how%20match%20many%20column%20times%20with%20many%20value%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3006745%22%20slang%3D%22en-US%22%3E%3CP%3Eyes.%20all%20i%20need%20is%201%20day%20to%20match%20so%20it%20could%20be%20any%3C%2FP%3E%3CP%3Ebut%20i%20recently%20finished%20that%20file%20by%20learning%20that%20i%20could%20sort%20cells%20by%20color%20it%20really%20helped%3C%2FP%3E%3CP%3Eattached%20is%20a%20new%20very%20similar%20file%3C%2FP%3E%3CP%3Ethis%20happens%20to%20me%20often%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20happens%20is%20i%20just%20need%20to%20match%20dates%20so%20they%20can%20graph%20properly%3C%2FP%3E%3CP%3Ein%20this%20example%20the%20green%20is%20successfully%20finished%20and%20reformatted%20by%20click%20and%20dragging%3C%2FP%3E%3CP%3Ethe%20yellow%20is%20unfinished%20data%20that%20is%20how%20it%20is%20pasted%20when%20i%20pulled%20the%20data%3C%2FP%3E%3CP%3Eis%20there%20a%20faster%20method%20than%20the%20way%20i%20am%20using%3F%3C%2FP%3E%3CP%3Ethanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

i have 3 time columns and 3 number columns 

how do i get all of the date and times to match for every result

my only way has to been to click and drag

i need all this to matchup so i can graph it properly

even if all the times dont matchup i at least could use the days 

thanks 

3 Replies

@dattmuffy Please clarify your intentions. For instance, Col A and C, both have three entries for the 16th of November with time and one without, whereas column E has only one single item for the day without time. Would you want to sum the values by day only?

yes. all i need is 1 day to match so it could be any

but i recently finished that file by learning that i could sort cells by color it really helped

attached is a new very similar file

this happens to me often 

what happens is i just need to match dates so they can graph properly

in this example the green is successfully finished and reformatted by click and dragging

the yellow is unfinished data that is how it is pasted when i pulled the data

is there a faster method than the way i am using?

thanks 

 

@Riny_van_Eekelen 

@dattmuffy Definitely, there is a faster way to achieve this. In the attached file, I used Power Query to merge two tables based on matching time stamps between the two of them. Creating the query took perhaps two minutes, and loading the end result back into Excel perhaps a few seconds.

 

You can re-use this over and over again as long as you copy new data into the two tables in the same format/structure and press "Refresh All" on the Data ribbon. See if this is something you can imaging using in the future. Learning some very basic PQ skills is all it takes.