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 IDFunding Account NameReport IDAmountad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR1239,092.843431,238.563245202452,061.735673,059.6 We want the data like below. Batch IDFunding Account NameReport IDAmountad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR1239,092.84ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR3431,238.56ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR324520ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR2452,061.73ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR5673,059.6 Regards, Mahesh

Merge row need to be seperate line

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

Developer

Accepted answers

OTrieger

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

PFA @Maheshp for the solution

Please mark as solution if you are happy

Merge row need to be seperate line solution.yxmd

All comments

Maheshp

Also attached the file.

Data1.xlsx

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

Swathi

PFA @Maheshp for the solution

Please mark as solution if you are happy

Merge row need to be seperate line solution.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703