Automatic fill the timeline table from source

Hello Everyone,

i have some Project data with man power list schedule as per project
what i need to do is to look up the manpower list from the project data and translate it into timeline tables of manpower resources
the difficult thing is the list of the manpower is morethan one column and have no idea what kind of formula needed to get what i want

attached is my working sheet table with left table in the sheet 2 as working sheet and expected result in the right table



i still look for another job scheduler format, if you have another working sheet for job scheduler, that would be fantastic

Please try at C6

=IF(SUMPRODUCT((INDEX('WORK SHEET'!$I$8:$AC$16,,MATCH(--(C$5&$C$4),'WORK SHEET'!$I$6:$AC$6,))="I")*('WORK SHEET'!$E$8:$H$16=$B6)),"I",IF(COUNTIFS($H$5:$I$5,C$5),"O",""))

oh, understood, so seems that i need to add countifs into the formulas as references source

thanks so much

thanks to bo_ry .... simply formulas ..