I would like to automatically add a blank row in a series of Dates so that when I graph the data there is a gap whenever there is a new month. This makes it alot easier to read when there is a bunch of data. The reason that I would like this done automatically is because I have several long lists of data that I can apply this to and it is very time consuming to manually add the blank rows. Can this be accomplished without a macro? I have an example below.
<tbody>
</tbody>
A | B | C | D | E | |
1 | Date | Data | Date | Data | |
2 | 1/5/2019 | 2 | 1/5/2019 | 2 | |
3 | 1/10/2019 | 4 | 1/10/2019 | 4 | |
4 | 1/15/2019 | 6 | 1/15/2019 | 6 | |
5 | 1/30/2019 | 8 | 1/30/2019 | 8 | |
6 | 2/1/2019 | 7 | |||
7 | 2/8/2019 | 12 | 2/1/2019 | 7 | |
8 | 2/17/2019 | 1 | 2/8/2019 | 12 | |
9 | 2/25/2019 | 14 | 2/17/2019 | 1 | |
10 | 3/1/2019 | 8 | 2/25/2019 | 14 | |
11 | 3/15/2019 | 1 | |||
12 | 3/1/2019 | 8 | |||
13 | 3/15/2019 | 1 | |||
<tbody>
</tbody>