[INDENT]Hi guys, I need a help with the Pivot Table please, I need to group text fields automatically by the first 3 characters, how could I do that? Noting that I need to do this in the same workbook because I came across some solution but it needed to create new workbook for the Pivot Table. I do not want to proceed with manipulating the raw data as well, I need to do this through the Pivot Table itself please.
Note: this post was published originally here but not sorted:
https://www.mrexcel.com/forum/…g-first-3-characters.html[/INDENT]