I'd like to ask a question about Power Queries, if I may.
My movie collection spreadsheet has three columns for actors.
Here's what I'd like to do, if it is possible:
I'd like to do a Power Query which gives me a total count for each individual actor, regardless of which column their name is in.
For example, I'd like to know how many movies Paul Newman is in, regardless of whether his name is in the Actor 1 column, the Actor 2 column, or the Actor 3 column.
Is this possible with Power Queries? Or do I have to use another Excel feature to do this?
If this can be done, I'd also like to do it for the Genre and Subgenre columns.
Thank you! Jd
My movie collection spreadsheet has three columns for actors.
Here's what I'd like to do, if it is possible:
I'd like to do a Power Query which gives me a total count for each individual actor, regardless of which column their name is in.
For example, I'd like to know how many movies Paul Newman is in, regardless of whether his name is in the Actor 1 column, the Actor 2 column, or the Actor 3 column.
Is this possible with Power Queries? Or do I have to use another Excel feature to do this?
If this can be done, I'd also like to do it for the Genre and Subgenre columns.
Thank you! Jd