Applying XLOOKUP, IF, TEXTSPLIT, and TRIM to my source data gives my PivotTable more useful fields and cleaner info to work with.

Jiwon Ma is a fact checker and research analyst with a background in cybersecurity, international security, technology, and privacy policies. Before joining Investopedia, she consulted for a global ...