Hi

first add a helper column with the formula =left(names,1)
then select your source ( including the helper column) and click "Insert table" - Change the name as required
use this table as source for your PT using the helper column as the first row field
each time row(s) are added, the table will adapt and the formula follows automatically
You just need to refresh your PT

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post