Use one piece of data for two rows without writing it twice- MS Access
<p>I apologise about the title, I'm not sure how to word it.</p>

<p>I have a table that looks like this:</p>

<pre><code>Name      |     Document     |     Notes
Company A |    Doc A Part 1  |   Withdrawn in Jan 2016
----------|------------------|------------------------
Company A |    Doc A Part 2  |   Withdrawn in Jan 2016
</code></pre>

<p>I want it to look like this:</p>

<pre><code>Name      |     Document     |     Notes
Company A |    Doc A Part 1  |   
----------|------------------| Withdrawn in Jan 2016
Company A |    Doc A Part 2  |    
</code></pre>

<p>Is there any way I can combine the 'Notes' field for those two rows so that they contain the same value; rather than writing out the note twice. The 'Notes' description will actually be much longer which is why I'd like to combine it. I know you can do this in excel; but I'm not sure if you can in access.</p>

<p>Also, if I do this, will I be denormalizing my data? Will I run into any complications; I just want both rows for that specific column to contain the same value without writing it twice.</p>