Insert column with pattern

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.

Column with pattern.yxmd

Output

Transformation

Accepted answers

JosephSerpis

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.

Column_With_Pattern.yxmd

All comments

JosephSerpis

Column_With_Pattern.yxmd

JosephSerpis

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

Column_With_Pattern.yxmd

binu_acs

@adarchuk another option using tile tool

Column with pattern.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703