Hi,

For this I recommend using concatenate along with index match formula:

1. Create a new column in column A, then in A4 use formula =Concatenate(B4, C4). Then copy this down for all of the data

2. You can then reference this in your output table. For example in cell B31 use "=INDEX($I$4:$I$25, MATCH($B31&"|"&C$30, $A$4:$A$25, 0)). Then copy this for all the cells in your output table

3. You can use =IFERROR([Step 2 formula], "") around this formula if you want to replace error messages with blanks

4. To count up the total non-blank cells you can use for example in your first row =COUNTA(C31:E31)-COUNTBLANK(C31:E31)

(Note also that because you have two instances of 1056M on 1st March - it will pick up the first instance and not the second)

I've created a similar GIFCoach for this here (using changed data):


https://www.gifcoach.com/how-to/spli...ng-indexmatch/