How to duplicate rows with unique values

[Theemeadelis]

I am enquiring if there is a function, or formula, or VBA that will allow me to create duplicate rows based on cells with unique values.

e.g. The below is a small sample of the data I need to create duplicate rows for:

I am hoping there is a formula, or function, or VBA etc. that will duplicate each row so that it shows 3 times, as below:

Thank you in advance for any help that can be provided.

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	A	A
3	B	A
4	C	A
5	D	B
6		B
7		B
8		C
9		C
10		C
11		D
12		D
13		D
Main

Cell Formulas
Range	Formula
B2:B13	B2	=TOCOL(IF(SEQUENCE(,3),A2:A5))
Dynamic array formulas.

 

[Theemeadelis]

How about

Fluff.xlsm
	A	B
1
2	A	A
3	B	A
4	C	A
5	D	B
6		B
7		B
8		C
9		C
10		C
11		D
12		D
13		D
Main

Cell Formulas
Range	Formula
B2:B13	B2	=TOCOL(IF(SEQUENCE(,3),A2:A5))
Dynamic array formulas.

That has worked perfectly - thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback.