In Excel, columnA I have values which need to be tripled in columnB
So I currently have
A
1 val1
2 val2
3 val3
I'd like each value to be tripled in column B, such as
A B
1 val1 val1
2 val2 val1
3 val3 val1
4 val2
5 val2
6 val2
7 val3
8 val3
9 val3
How can I do this?