A similar scenario: You have the same need as defined above where you would like to convert the positions of First Baseman, Second Baseman, Third Baseman, and Shortstop to be identified as just "Infielder." However, you know that the input csv file will be updated each season $$ so you will have to repeat the data conversion process every season. Given that you will have to repeat it$,$ which two of following approaches would make the process easily repeatable. Choose all that apply.

Question $4$ options:

Create a new Measure for infielders in Power Pivot

Use Replace Values in Power Query

Import the data into an Excel sheet and use Text to Columns

Import the data into an Excel sheet and use Find and Replace

Use a merge Query in Power Query

Create a Conditional Column in Power Query