Increasing number sequences

[P47R1ck]

Hi, I am looking to be able to increase number sequences as shown in picture. Column A has the same number of entries as the number, column B increases up to the number - sorry not easy to explain, hope the picture covers it. I can do it manually but will take hours as I have to go into the hundreds with this. Any help greatly appreciated

-- removed inline image ---

 

[P47R1ck]

sorry new to this, not sure if the image was shown. will type below what I am after
Column A Column B
1 1
2 1
2 2
3 1
3 2
3 3

 

[shg]

Welcome to the board.

Row\Col	A​	B​	C​	D​
1​
2​	1​	1​		A2 and down: =INT(SQRT(2*ROWS(A$2:A2)) + 0.5)
3​	2​	1​		B2 and down: =IF(A2=A1, B1+1, 1)
4​	2​	2​
5​	3​	1​
6​	3​	2​
7​	3​	3​
8​	4​	1​
9​	4​	2​
10​	4​	3​
11​	4​	4​
12​	5​	1​
13​	5​	2​

 

[P47R1ck]

Thank you so much. Me and 3 colleagues have spent hours looking at this. Am amazed how quickly the right answer came. shg you are a star! I am going to love this site. Once again, thank you!

 

[shg]

Straight from the OEIS: https://oeis.org/A002024

You're welcome.