1/1/18 | 20 | 1/1/18 | 12 | 20 |
2/1/18 | 25 | 1/1/18 | 16 | 20 |
3/1/18 | 35 | 1/1/18 | 15 | 20 |
4/1/18 | 32 | 2/1/18 | 4 | 25 |
5/1/18 | 80 | 2/1/18 | 56 | 25 |
3/1/18 | 3 | 35 | ||
4/1/18 | 23 | 32 | ||
4/1/18 | 12 | 32 | ||
5/1/18 | 3 | 80 | ||
5/1/18 | 4 | 80 |
<tbody>
</tbody>
So I'm basically trying to create the column with the red text. Matching column B data next to the column D data but just putting a re-occurring value in for the corresponding data from the same date.
Any thoughts?