I have for example an excel spreadsheet (bank transaction export).
Say the file contains 5 columns; Date, Tx Details, Amount, Category, Sub-Category
If for example the ‘Tx Details’ column contained the text either ‘Coles’ or ‘Woolworths’
How can I bulk update
the ‘Category’ column with the text ‘Expenses’ and
the ‘Sub-Category’ column with the text '‘Groceries’
or …… is this type of update better handled elsewhere in PBI?