Hi, Hope you're all keeping well.
I was hoping someone could point me in the right direction of a formula / function that can help break down large sections of text. If someone could point me in the right direction, I should be able to work out the nuances and implementation myself.
I have an API that exports data into a single column. I need this information spread out over a number of different columns.
Screenshot of the Smartsheet below, and a highlighted version from word showing the individual columns required.
Any advice would be greatly appreciated.
Note: the start of the text extract required will always be a product code, i.e "K Pegs" or "WBS1(425)" etc from the example below. Although the contents of each item will not always be equal in length - It will need to extract data starting from one product code, and ending before the next product code.
Cheers all who have read!