Insert column with pattern

[adarchuk]

I have a column of data that has a pattern that includes null values.  It needs to be transposed to include the null values.  Essentially, rows 1-4 is a set of data that I need to get into one row.  Rows 5-8 is the next set of data that I need to get transposed into one row.  The pattern continues with each group of 4 rows.  I've included a sample of the 1200 rows of data.

[JosephSerpis · Accepted solution]

Hi @adarchuk you can use a multi-row tool to create the pattern of 1-4. Attached a workflow to showcase this. If you had some logic or pattern within the data you could assign the numbers more dynamically. I have just set a If condition in the Multi-Row tool that will add 1 until 4 and then start at 1 again.

[JosephSerpis]

Hi @adarchuk I gave a crack at building in some logic based on the data to build the pattern using regex.

[binu_acs]

@adarchuk another option using tile tool