I have tried to look for this in the existing posts but I'm not really sure what to search for. Due to restrictions as at work I'm looking to solve this with standard Excel formula and not customs or VBA.
The data that I have is variable, the number of data in the cell against each month will vary in quantity. Hopefully it can be simply represented for the purposes of this question as the left side. The output that I'm looking for is the right side. Any ideas
<tbody>
</tbody>
The data that I have is variable, the number of data in the cell against each month will vary in quantity. Hopefully it can be simply represented for the purposes of this question as the left side. The output that I'm looking for is the right side. Any ideas
| Jan | A | Jan | A | |
| Feb | B, C | Feb | B | |
| Mar | D, E, F | C | ||
| Apr | G | Mar | D | |
| May | H, I, J, L, K | E | ||
| F | ||||
| Apr | G | |||
| May | H | |||
| I | ||||
| J | ||||
| K | ||||
| L |
<tbody>
</tbody>
