Split columns into multiple columns

[susukavi]

Hi ,

 I want to capture sequence of each id and update in table.If there is no sequence for that id,need to mark as null.

Kindly help me

My Input is 

id   date  seq

100 11/17 1

100 11/17  2

100 11/17 3

101 11/17 1

101 11/17 2

101 11/17 1

101 11/17 2

101 11/17 3

Required output is

id date seq1 seq2

100 11/17 1 null

100 11/17 2 null

100 11/17 3 null

101 11/17 1 3

101 11/17 2 2

101 11/17 null 1

[PhilipMannering · Accepted solution]

Hi @susukavi 

Maybe something like this... See attached.

[susukavi]

Thanks Philip..it worked