How to pivot data

[Punnu]

I have data like this 

id	time	Conatcts
x1	4/22/2011 10:00	676689
x1	4/23/2011 11:00

I want it like as shown below : Lw_mesage time is time when conatctid column is null  and other when conatcid column has value 

id	lw_message_time	standardised  message
x1	4/23/2011 10:00	4/23/2011 11:00

[PickleRick]

First tag your event with one of two classes

| eval type=if(isnull(contactid),"lw_message","standardised_message")

And then do

| xyseries id type time