I have a data in this format
Date Day Time Confirmed Home Page UV's Search Page UV's Ratio of H.S & H.P
conversion this hour UV's
1-Feb Fri 9:30 AM 424 8456 4047 0.481 0.1088
1-Feb Fri 10:30 AM 615 13689 6749 0.5163 0.0707
1-Feb Fri 11:30 AM 926 19872 10104 0.5426 0.0927
1-Feb Fri 12:30 PM 1247 27366 13842 0.4988 0.0859
1-Feb Fri 1:30 PM 1584 34334 17307 0.4973 0.0973
1-Feb Fri 2:30 PM 1895 41185 20761 0.5042 0.09

& I want to re arrange this data like below

Day Date Time Activity Value Data Type
Monday 13-Aug 10:30AM Confirmed 256 Daily
Monday 13-Aug 10:30AM Home Page NA Daily
Monday 13-Aug 10:30AM Search NA Daily
Monday 13-Aug 10:30AM Ratio 0 Daily
Monday 13-Aug 10:30AM Conversion NA Daily
Monday 13-Aug 11:30AM Confirmed 418 Daily
Monday 13-Aug 11:30AM Home Page NA Daily
Monday 13-Aug 11:30AM Search NA Daily
Monday 13-Aug 11:30AM Ratio 0 Daily
Monday 13-Aug 11:30AM Conversion NA Daily

Please help me to do this.