Shifting data Up

[Rhaldhar]

Hi, 

I am trying to shift data up in the top row. I have two data set DataA and DataB and doing following way please help me to get correctly and suggest the way how I can get.

DataA							DataB
A	B	C	Amount	Unique  id			Unique  id	Name	Amount
Rajesh	63	55	27	1			1	Rajesh	107
Rajesh	97	93	80	1			2	Suresh	29
Suresh	18	37	8	2			3	Naresh	191
Naresh	49	44	97	3			4	Kartik	85
Suresh	7	89	21	2			Grand Total		412
Kartik	96	18	46	4
Kartik	91	7	39	4
Naresh	71	62	18	3
Naresh	10	3	76	3

Using Union tool and getting below data.

A	B	C	Amount	Unique  id	Name	Amounts
Rajesh	63	55	27	1	[Null]	[Null]
Rajesh	97	93	80	1	[Null]	[Null]
Suresh	18	37	8	2	[Null]	[Null]
Naresh	49	44	97	3	[Null]	[Null]
Suresh	7	89	21	2	[Null]	[Null]
Kartik	96	18	46	4	[Null]	[Null]
Kartik	91	7	39	4	[Null]	[Null]
Naresh	71	62	18	3	[Null]	[Null]
Naresh	10	3	76	3	[Null]	[Null]
[Null]	[Null]	[Null]	[Null]	1	Rajesh	107
[Null]	[Null]	[Null]	[Null]	2	Suresh	29
[Null]	[Null]	[Null]	[Null]	3	Naresh	191
[Null]	[Null]	[Null]	[Null]	4	Kartik	85

Using output tool to get data in different tab on basis of Unique number then getting this way, giving an example

A	B	C	Amount	Unique  id	Name	Amounts
Rajesh	63	55	27	1	[Null]	[Null]
Rajesh	97	93	80	1	[Null]	[Null]
[Null]	[Null]	[Null]	[Null]	1	Rajesh	107

But I want the data in this way, null cell should not there in last two column and available data come up as showing below screen.

A	B	C	Amount	Unique  id	Name	Amounts
Rajesh	63	55	27	1	Rajesh	107
Rajesh	97	93	80	1
[Null]	[Null]	[Null]	[Null]	1

Thanks,

Rajeev

[Raj · Accepted solution]

@Rhaldhar 
find the workflow attached
mark done if solved.

[binuacs]

@Rhaldhar try join instead of union

[Rhaldhar]

Thank you @Raj  perfect solution.

[Rhaldhar]

Thank you @binuacs  for looking the query.