Column filling

[#1]

Hi,

I have a table of data containing several hundred rows and need to create a column that is filled with incremental numeric values, the twist is that I require the incremental fill to follow as below:  The column is called "sample" and row 1 value = 1, row 2 value = 1, then increment by 1, so that row 3 value = 2, row 4 value = 2 and continue to the end of the data file.

 sample
 1
 1
 2
2
 3
 3
 4
 4
 5

Any thoughts?
e 5
s 6
e 6
s 7

[#2]

Please ignore the last few lines of my post...those should not have been sent.

Thank you

[#3]

You should be able to use Lag() function to get what you want .

Can you provide a screenshot of the exact output you are after ?

[#4 · Accepted solution]

Try the Sequence() function.

[#5]

Jeff,

Thank you.  Sequence worked perfectly.

Cheers!