Repeat All Item Labels

Hi Team,

Just a help required. I have the below data

Order	ID	CONCATENATE	DATE	CODE	FACTOR
123456	0156	1234560156	3/2020	G	1.26
Check1				s
245567	0157	2455670157	3/2020	g	8.56
Check2				s

Concatenate has to be done only for 1st and 3rd row in the concatenate column and the previous row information has to be filled on the blank cells

Output should be in the below format

Order	ID	CONCATENATE	DATE	CODE	FACTOR
123456	0156	1234560156	3/2020	G	1.26
Check1		1234560156	3/2020	s	1.26
245567	0157	2455670157	3/2020	g	8.56
Check2		2455670157	3/2020	s	8.56

Can someone help me on this please?

Preparation

Accepted answers

atcodedog05

Hi @Jeyaraj_M

Here is a workflow for the task.

Output:

Workflow:

I have modified so that a single Mutli-row formula would work on all columns selected in Transpose tool.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

fillup.yxmd

All comments

TheOC

HI @Jeyaraj_M

I believe I have created a workflow that acheives this:

Using multi-row formula's, if the row contains no value for concatenate or factor, it takes the one from above.

Hope this helps!

Jeyaraj_M.yxmd

Jeyaraj_M

Thanks for your prompt response.

But in the output still the Date column has the null values.

My data contains few other column on the same scenario where the blank cells has to be filled from the top row.

Can you please help me on that?

atcodedog05

Hi @Jeyaraj_M

Here is a workflow for the task.

Output:

Workflow:

I have modified so that a single Mutli-row formula would work on all columns selected in Transpose tool.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

fillup.yxmd

Jeyaraj_M

Thank you so much for your help....

TheOC

hi @Jeyaraj_M

Here is a solution that works with your data, i just added another multi-row.

However, @atcodedog05 is more elegant for more data columns!

Glad you got it sorted 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703