I have a dataset that looks like this
left | center | right |
---|---|---|
One | data | data |
data | data | |
data | data | |
data | data | |
Two | data | data |
data | data | |
data | data | |
data | data | |
Three | data | data |
data | data | |
data | data | |
data | data |
What I need it to do is to look like this
left | center | right |
---|---|---|
One | data | data |
One | data | data |
One | data | data |
One | data | data |
Two | data | data |
Two | data | data |
Two | data | data |
Two | data | data |
Three | data | data |
Three | data | data |
Three | data | data |
Three | data | data |
The core issue as you can see is that I have a single value that is only within one row but needs to be in all the associated rows.