|Hi, i have this excel data table|
Date Application No. Calls Type
1/25/2012 Login 36 Login
Call Back 21 PC Software
Business Apps 32 PC Software
Apps 49 Printer
Outlook 13 Firecall
These all are cell A1,B1,C1,D1, though it looks messed up there but all application,calls and types are below eachother and date in first cell , i have to break it into multiple cell such as for each 5 same date 1/25/2012 on one row will have corresponding data.
1/25/2012 Login 36 login
1/25/2012 Business App 32 PCSoftware
I know i have to use VBA but don't have idea please help me.