Forum Discussion
How can I transpose?
phildot See attached.
phildot See attached.
One additional question: what if I want to have a second field to be checked here, e.g; to check A12 and A14?
=IFERROR(INDEX($A$2:$A$5;MATCH($A12;B$2:B$5;0);1);"")
phildot And what would be the result you would want to see then?
My problem is precisely regarding resource planning crossed tables.
I have this origin table, filled in by the Conso team lead.
where is for On duty and / is for absent/off duty
I have to transpose it like this for a table that gathers several teams, where Name means "is working/present" and red means "absent"
Your formula helps me getting the name, by using P as the matching variable, but I'd need to have the "/" variable checked as well to render another result (red box or anything else, or name with in grey/red...
Not an easy one, I guess.
Anyway, thanks Riny for your time.
Phil
phildot Perhaps like in the attached file (columns G:J)?
Done with a simple IF statement that picks up the name from the left column in case of a "P", and leave blank if there is anything else but a "P". Then use Conditional Formatting to color blank cells red.
If this is not what you are looking for, please extend your example with a few more possible situations, as I don't really understand where the "Conso team lead" comes in here. But I guess you have several teams and you want to, somehow, summarise all workers' schedules into one table.