cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
Hello everyone! I'm in a new position where I'm allowed to use PQ and PP again.
As always, I apologize if I am not asking this using the best terms:
I need to create a column within Power Query that indexes according to the column "SiteVisit".
The TL (Team Lead) is present in every site visit, but sometimes there are three persons, so a simple IF/Then statement won't work.
<tbody>
</tbody>
Glad to be back and have your help again.
Thanks for your patience, too!
Cliff
As always, I apologize if I am not asking this using the best terms:
I need to create a column within Power Query that indexes according to the column "SiteVisit".
The TL (Team Lead) is present in every site visit, but sometimes there are three persons, so a simple IF/Then statement won't work.
SiteVisit | Person | CustomColumn |
9 | TL-IP | 1 |
9 | DH | 2 |
9 | RR | 3 |
10 | TL-GQ | 1 |
10 | AR | 2 |
10 | TH | 3 |
11 | TL-MN | 1 |
11 | JJ | 2 |
12 | TL-PF | 1 |
12 | KK | 2 |
13 | TL-ST | 1 |
13 | BM | 2 |
<tbody>
</tbody>
Glad to be back and have your help again.
Thanks for your patience, too!
Cliff