Regrouping Delimited Data
I pull data from an internal system and add it to Smartsheet via Data Uploader. When it comes in, it looks like the above, with Biz Entity, Sub Business Entity and Product Family grouped as delimited data. However, I want to regroup it so that each Biz Entity/Sub Business Entity/Product Family group is together in a single cell - like this:
Data Center Networking-NX9K-APIC
This has turned into a nightmare scenario where I am exporting the data from the internal system to Excel, converting the delimited data to columns, trimming the data to remove leading spaces, then regrouping it using TEXTJOIN before running it through Data Uploader. The result is adding dozens of otherwise useless columns to the sheet, and I have to believe there is an easier way to do this, but I'm scratching my head. Any ideas?
Help Article Resources
Check out the Formula Handbook template!