Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting data to tally format
I couldn't think of a better header, sorry. Anyway, I have data tha comes in like this (via a plain text file) Code ------------------- 1-Jan-06 Exploit.W32.MS05-039 1-Jan-06 HTML.Phishing.Auction-28 1-Jan-06 HTML.Phishing.Bank-1 1-Jan-06 HTML.Phishing.Bank-1 1-Jan-06 HTML.Phishing.Bank-1 1-Jan-06 HTML.Phishing.Bank-209 1-Jan-06 HTML.Phishing.Bank-28 1-Jan-06 HTML.Phishing.Pay-6 1-Jan-06 W32/Bagle.ai@MM 1-Jan-06 Worm.Sober.U-3 1-Jan-06 Worm.Sober.U-3 1-Jan-06 Worm.Sober.U-3 1-Jan-06 Worm.Sober.U-3 2-Jan-06 HTML.Phishing.Bank-1 2-Jan-06 HTML.Phishing.Bank-1 2-Jan-06 HTML.Phishing.Bank-1 2-Jan-06 HTML.Phishing.Bank-206 2-Jan-06 HTML.Phishing.Pay-25 2-Jan-06 HTML.Phishing.Pay-37 2-Jan-06 HTML.Phishing.Pay-43 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 W32/Bagle.ai@MM 2-Jan-06 Worm.Sober.U-3 2-Jan-06 Worm.Sober.U-3 2-Jan-06 Worm.Sober.U-3 2-Jan-06 Worm.Sober.U-3 3-Jan-06 HTML.Phishing.Auction-28 3-Jan-06 HTML.Phishing.Auction-28 3-Jan-06 HTML.Phishing.Auction-28 3-Jan-06 HTML.Phishing.Bank-1 3-Jan-06 HTML.Phishing.Bank-1 3-Jan-06 HTML.Phishing.Bank-28 3-Jan-06 HTML.Phishing.Pay-34 3-Jan-06 HTML.Phishing.Pay-37 3-Jan-06 W32/Bagle.ai@MM 3-Jan-06 W32/Bagle.ai@MM 3-Jan-06 W32/Bagle.ai@MM 3-Jan-06 W32/Netsky.p@MM 3-Jan-06 W32/Netsky.p@MM 3-Jan-06 W32/Netsky.p@MM 3-Jan-06 Worm.Sober.U-3 3-Jan-06 Worm.Sober.U-3 3-Jan-06 Worm.Sober.U- ------------------- And what I'd like to accomplish is a sheet that looks like the attache example, which reflects the month of February (as opposed to the abov data which is from January.) Basically a listing of how many o whatever virus came in on any particular day. Any suggestions +------------------------------------------------------------------- |Filename: excel-virus.gif |Download: http://www.excelforum.com/attachment.php?postid=4480 +------------------------------------------------------------------- -- AMK ----------------------------------------------------------------------- AMK4's Profile: http://www.excelforum.com/member.php...fo&userid=1914 View this thread: http://www.excelforum.com/showthread.php?threadid=52407 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting data to tally format
if the data is all in one column, then select the column and do Data=Text
to columns, select delimited and space s the delimiter. this should put the data in two columns. Insert a row at the top and put in header DATE VIRUS then select the Data=Pivot Table Report when you to the dialog with Layout, put VIRUS as a row field by dragging the Virus button to the row area. Also drag it to the data area an it should default to count. Drag Date to the Column Area Not OK the pivot table. the date will probably be vertically oriented. Select the DATA button at the top with the mouse and drag slightly to the right and release. They should reorient to a horizontal orientation. -- Regards, Tom Ogilvy "AMK4" wrote in message ... I couldn't think of a better header, sorry. Anyway, I have data that comes in like this (via a plain text file): Code: -------------------- 1-Jan-06 Exploit.W32.MS05-039 1-Jan-06 HTML.Phishing.Auction-28 1-Jan-06 HTML.Phishing.Bank-1 1-Jan-06 HTML.Phishing.Bank-1 1-Jan-06 HTML.Phishing.Bank-1 1-Jan-06 HTML.Phishing.Bank-209 1-Jan-06 HTML.Phishing.Bank-28 1-Jan-06 HTML.Phishing.Pay-6 1-Jan-06 W32/Bagle.ai@MM 1-Jan-06 Worm.Sober.U-3 1-Jan-06 Worm.Sober.U-3 1-Jan-06 Worm.Sober.U-3 1-Jan-06 Worm.Sober.U-3 2-Jan-06 HTML.Phishing.Bank-1 2-Jan-06 HTML.Phishing.Bank-1 2-Jan-06 HTML.Phishing.Bank-1 2-Jan-06 HTML.Phishing.Bank-206 2-Jan-06 HTML.Phishing.Pay-25 2-Jan-06 HTML.Phishing.Pay-37 2-Jan-06 HTML.Phishing.Pay-43 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 HTML.Phishing.Pay-6 2-Jan-06 W32/Bagle.ai@MM 2-Jan-06 Worm.Sober.U-3 2-Jan-06 Worm.Sober.U-3 2-Jan-06 Worm.Sober.U-3 2-Jan-06 Worm.Sober.U-3 3-Jan-06 HTML.Phishing.Auction-28 3-Jan-06 HTML.Phishing.Auction-28 3-Jan-06 HTML.Phishing.Auction-28 3-Jan-06 HTML.Phishing.Bank-1 3-Jan-06 HTML.Phishing.Bank-1 3-Jan-06 HTML.Phishing.Bank-28 3-Jan-06 HTML.Phishing.Pay-34 3-Jan-06 HTML.Phishing.Pay-37 3-Jan-06 W32/Bagle.ai@MM 3-Jan-06 W32/Bagle.ai@MM 3-Jan-06 W32/Bagle.ai@MM 3-Jan-06 W32/Netsky.p@MM 3-Jan-06 W32/Netsky.p@MM 3-Jan-06 W32/Netsky.p@MM 3-Jan-06 Worm.Sober.U-3 3-Jan-06 Worm.Sober.U-3 3-Jan-06 Worm.Sober.U-3 -------------------- And what I'd like to accomplish is a sheet that looks like the attached example, which reflects the month of February (as opposed to the above data which is from January.) Basically a listing of how many of whatever virus came in on any particular day. Any suggestions? +-------------------------------------------------------------------+ |Filename: excel-virus.gif | |Download: http://www.excelforum.com/attachment.php?postid=4480 | +-------------------------------------------------------------------+ -- AMK4 ------------------------------------------------------------------------ AMK4's Profile: http://www.excelforum.com/member.php...o&userid=19143 View this thread: http://www.excelforum.com/showthread...hreadid=524078 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting data in column to Phone Format | Excel Discussion (Misc queries) | |||
Converting data Format | Excel Discussion (Misc queries) | |||
Converting data to list format | Excel Discussion (Misc queries) | |||
create tally sheet for positions- insert names and tally # | Excel Discussion (Misc queries) | |||
code for converting data format in another format | Excel Programming |