Multiple Condition Lookup Array

[Finalfight40]

Hi All

I have a spreadsheet which looks like below:

Sheet1:

A	B	C	D	E
PROJECT	START DATE 1	END DATE 1	START DATE 2	END DATE 2
A	07/01/2018	06/04/2018	01/06/2018	01/09/2018
B	04/04/2018	05/07/2018
C	04/04/2018	07/07/2018
D	10/10/2018	02/02/2019
E	01/01/2018	02/03/2018	05/06/2018	03/08/2018
F	17/03/2018	18/04/2018

<tbody>
</tbody>

What i am looking for on sheet 2 is a list of the projects like below:

Jan 18	Feb 18	Mar 18	Apr 18	May 18	June 18	July 18	Aug 18
A	A	A	A	B	B	B	A
E	E	E	B	C	C	C	E
		F	C		A	A
			F		E	E

<tbody>
</tbody>

I am using the formula to pull through the first date to the second sheet and then adding a month every time.

=DATE(YEAR(MIN(Sheet1!B2:B500)), MONTH(MIN(Sheet1!B2:B500)), 1)

The order the projects appear in would not matter.

Solution can not be VBA as they might be looking to import this into Googlesheets.

Hopefully this is clear but if not, please let me know.

Any help would be appreciated.

 

[Special-K99]

Not saying I'll answer this
but it would be easier for formulas to have one project on one line, ie 1st Line June 18 July 18 are Bs, would be easier if they were As.
Any reason why you put dropped A in place of B on that line ?

Also your example data implies they are only TWO data ranges per project.

 

[Finalfight40]

Not saying I'll answer this
but it would be easier for formulas to have one project on one line, ie 1st Line June 18 July 18 are Bs, would be easier if they were As.
Any reason why you put dropped A in place of B on that line ?

Also your example data implies they are only TWO data ranges per project.

Hi Special-k99

The reason Project A got dropped for June and July is because the end date 1 month is April and it appears again on start date 2 in June hence the reason it reappears.

I am trying to avoid having them spaced out having a project per line as there are around 50 projects and growing and it would contain a lot of blank spaces.