This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a data formatted like Table 1 this but I want to format it like Table 2. Can anyone suggest a dynamic way to do this?
Customer A50100150Customer B60110160Customer C80120180
You could parse the table using Regex:
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
My solution is also very similar to Jonathan's, however if you are not familiar with Regex, contain statements might be a bit more simple to understand. Both work great however!