Repeat All Item Labels

[Jeyaraj_M]

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?

[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]

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?

[mceleavey]

Hi @Jeyaraj_M ,

You would need to copy the multi-row formula tools that @TheOC  has written for each column you want to fill in.  For example, if isempty ([DATE]) then [Row-1:DATE] else [DATE] endif to fix the date field etc.

I would recommend including a Data Cleansing tool after the input if you have leading or trailing spaces.

M.

[atcodedog05 · Accepted solution]

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 😀👍

[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 🙂 

[atcodedog05]

Happy to help 🙂 @Jeyaraj_M 

Cheers and Happy Analyzing 😀