Splitting input based on text

Skotland

Hi,

I have a sheet with SLA data for our phone lines. My problem is that the output is just text based, and provides only titles in the .csv. I would like to add the title of the queue to each line below, for every queue. See screenshot below. The queue name also changes further down in the dataset so I need this to be dynamic. Is this possible? Thanks!!

danilang

hi @Skotland 

You can use something like this to copy the queue header info to each row

Use a mulit-row tool to define the Queue number of each group of records.  The sample tool takes the first record of each of these groups which is then joined by Queue to the original data, resulting in

BTW.  When you're looking for a solution that involves data, attach a sample of the actual data as opposed to an image.  People are more likely to respond if they don't have to manually enter a long list.

Dan

Split.yxmd