I've a dataset similar to:
A B C D
a1 b1 c1 .
a1 b1 c2 .
a1 b1 c3 .
a1 b1 c4 123
a1 b2 c1 .
a1 b2 c2 .
a1 b2 c3 .
a1 b2 c4 456
I am looking for output similar to :
A B C D
a1 b1 c1 123
a1 b1 c2 123
a1 b1 c3 123
a1 b1 c4 123
a1 b2 c1 456
a1 b2 c2 456
a1 b2 c3 456
a1 b2 c4 456
Thanks in advance for helping me in coding this.