Multi Row Formula Help

[WestonProhaska]

Hi Everyone, I'm back with a question about the multi row formula tool. 

So, I have data that looks like this that I've used a find replace to set up and see if its even possible to do. 

Account	Account desc	X	Y	Z	Acct2	Account desc2	x2	y2	z2
32KS64012	ABC	IS	MKTG	2700	null	null	null	null	null
32KS64209	DEF	IS	MKTG	7200	32KS6420	DEG	IS	MKTG	4500
32KS64012	GHI	IS	MKTG	1200	null	null	null	null	null

The information starting at Acct2 and onward is appended based on similarity because they are new accounts. I want to keep the ordering of my data on the left but add the new information in rows below where the Account is similar. So the new information would look like this essentially. 

Account	Account desc	X	Y	Z	Acct2	Account desc2	x2	y2	z2
32KS64012	ABC	IS	MKTG	2700	null	null	null	null	null
32KS64209	DEF	IS	MKTG	7200	32KS6420	DEG	IS	MKTG	4500
32KS6420	DEG	IS	MKTG	4500	null	null	null	null	null
32KS64012	GHI	IS	MKTG	1200	null	null	null	null	null

What is left over on the last fields from acct2 and on doesn't matter to me as I won't need them after adding it to the row below.

I can provide you examples of the data sets before appending them if you think using something other than a multi row formula tool would be better suited. 

Thank you in advance!!

[fmvizcaino · Accepted solution]

Hi @WestonProhaska ,

I am not sure if this is the easiest way of doing it, but I nailed for the examples you shared here.

Let me know if that works for you or if we need to do some tuning.

Best,

Fernando Vizcaino

[WestonProhaska]

@fmvizcaino I dont know how you do it, but you are magical every time. 

Thank you.