Merging multiple rows to one
Posted on 2016-11-22
My Data starts as A1 has header of Function, B1 has header Activity, C1 has header Start Date, D1 has Start Time, E1 has header End Date, F1 has header End Time & G1 as header Quantity.
Suppose my I have Function in A2, Activity in B2, Multiple Start Dates from C2 to C5, Multiple Start Time from D2 to D5, Multiple End Dates from E2 to E5, Multiple End Times from F2 to F5 & Multiple Quantity from G2 to G5.
Quantity is the difference of Start Date - Start Time to End Date - End Time.
For instance, 100012 function in A2 has 01/10/2016 as start date in B2, 00:00 in C2 as start time, 07/10/2016 as end dates in D2, 23:59 in E2 as end time. and continues different dates and time until B5 to E5.
It must check the first date (not the 1st of Oct, but it would be any start date in Oct) in Start Date and last date (not the 31st of Oct, but it would be any last date in Oct) in End Date, sum the quantity for particular Function in another sheet with just 1 row with all the column headers.