| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rearranging rows & Cloumn( Please help me)
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rearranging and organizing data imbedded in rows | Excel Discussion (Misc queries) | |||
| I am looking for a imple formula for excel i need Cloumn be to be | Excel Discussion (Misc queries) | |||
| how do i change an incorrect amount in a cloumn after download | Excel Worksheet Functions | |||
| copying data from matching cloumn | Excel Worksheet Functions | |||
| Rearranging columns/rows | Excel Discussion (Misc queries) | |||
Threaded Mode
