Macro to duplicate row based on cell value

[rscartoni]

Hi Guys,

I have tried to re-search previously threads on this but could not find an answer.

So I have an list of 474 groups which I need to copy each of the 3times. so result should be the value on column plus 3x it.

I.E.
Column A
01-01-01
01-02-01
01-02-02
01-02-03

Result should be:
01-01-01
01-01-01
01-01-01
01-01-01
01-02-01
01-02-01
01-02-01
01-02-01
01-02-02
01-02-02
01-02-02
01-02-02
01-02-03
01-02-03
01-02-03
01-02-03


Really appreciate any support.