Hello,
I have the following data:
Eng# —Agreement
111 ------LA1234
111 ------SC4567
333------ LA9877
I need to establish that for each Eng# I have both SC* and LA*. I am sure there are many ways to do so. I was thinking to loop through the rows for the same Eng# and collect the first 2 characters of the Agreement to get to
Eng# ---- Collection
111 --------LA, SC
333--------LA
How can I achieve this? Please help.
