Adding new row into column with changing the format.

[ravikumar060987]

Dear Experts, Which tool and condition, logic need to use to get the required output?

		Input
Category	Set	Item Type	Ex Type	Quantity	Available Position	Ageing
MY DATA	MY-1	SP	PSS	400000	400000	60
		Difference Quantity		400,000.000
MY DATA	MY-1	LP	BP	50000	50000	39
MY DATA	MY-1	SP	BP	50100	50000	39
		Difference Quantity		100.000

		Output
MY DATA	MY-1	SP	PSS	400000	400000	60	Difference Quantity	400,000.000
MY DATA	MY-1	LP	PB	50000	50000	39	Difference Quantity	100.000
MY DATA	MY-1	SP	PB	50100	50000	39	Difference Quantity	100.000

[ShankerV]

Hi @ravikumar060987 

You can achieve the below with the helps of tools Multirow formula, Filter and then Join.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ravikumar060987]

@ShankerV - But while Joining back the data - am not getting correct values. Can you please share the workflow?

[ShankerV]

Hi @ravikumar060987 

Sure, sharing the workflow.

Many thanks

Shanker V

[ShankerV]

Hi @ravikumar060987 

Please find the expected output.

Input was:

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @ravikumar060987 

Step 1: Input

Step 2:

Step 3:

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @ravikumar060987 .

Step 4: 

Step 5: 

Step 6:

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @ravikumar060987 

Step 7: Join tool

Last step: Browse tool to show the output

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[binuacs · Accepted solution]

@ravikumar060987 One way of doing this