Filling Empty Cells

[#1]

Hello experts,

I am trying to do the following.  I have a table that has a column of vendor IDs and another column with line numbers.  The problem is that is there are multiple lines, which is almost always the case, the vendor number will only appear in the last line.  I also have a copy of this vendor number column as a new column.  I would like to pupulate the cells in the new row with the vendor number of the last line in the invoice.  For example:

I have:

Invoice     Line Number     Vendor1     NewVendor    

1               1             

1               2

1               3                         101

2               1         

2               2

2               3

2               4    

2               5                         102

What I would lke is:        

Invoice     Line Number     Vendor1     NewVendor    

1               1                                              101

1               2                                              101   

1               3                         101               101

2               1                                              102

2               2                                              102

2               3                                              102

2               4                                              102

2               5                         102               102

Any ideas how I could perhaps sort descending and peek back??

Thanks,

Dave

[#2]

1000 thanks to Jagan....after some modifications it appears to work perfectly!  Thanks again.  Dave

[jagan]

The Correct Answer should be given to the post which helps you in finding the Answer and not for your question. 

[qlikviewwizard]

Hi davidjgilligan,

select Correct Answer to jagan reply. Thanks.

You wrongly selected your reply.

[#5]

Done.  Sorry, must be these double emails I keep getting from the Wizard.  Very annoying.  Sorry, Jagan, didn't mean to choose my own, my mistake.  This is a great forum with great help except for this wizard thing. 

[jagan]

No Problem.