Merge row need to be seperate line

[Maheshp]

Hi Team,

As per below screen shot, you can see the Batch ID which has been merged between 5 rows, is there any way where we can get in each and every row. 

Batch ID	Funding Account Name	Report ID	Amount
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92	JWS UK JPM EUR	123	9,092.84
343	1,238.56
3245	20
245	2,061.73
567	3,059.6

We want the data like below.

Batch ID	Funding Account Name	Report ID	Amount
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92	JWS UK JPM EUR	123	9,092.84
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92	JWS UK JPM EUR	343	1,238.56
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92	JWS UK JPM EUR	3245	20
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92	JWS UK JPM EUR	245	2,061.73
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92	JWS UK JPM EUR	567	3,059.6

Regards,

Mahesh

[Maheshp]

Also attached the file.

[OTrieger]

@Maheshp 

One way to do it is by using Multi Row Formula to get the text into the blank rows. I can see that in Alteryx all the data is sitting correctly in the correct column therefore no additional action is needed.

[Maheshp]

Can we see the example, as i am doing but it is not working.

[OTrieger · Accepted solution]

You will need to use IF formula

IF [Field]=Null() AND  [Row-1:Field]!=Null() THEN  [Row-1:Field] ELSE  [Field] ENDIF

If does not work then share a screen on what do you see and which error do you get if you get any

[Swathi · Accepted solution]

PFA  @Maheshp for the solution

Please mark as solution if you are happy