Copying value to multiple rows.

[walkingbird]

Hi, i have a table as below with two columns 

System.Username.*@DLLLSLS	1
Flying:ALL(UPDATE)	0
ReadAccess:$XXXXX,$DDDD(G)	0
UpdateAccess:HELLO	0
ControlAccess:BYE	0
AlterAccess:$XXXX(X)	0
AccessNone:No	0
	0
System.Username.*@XXXX	1
Flying:FEW(UPDATE)	0
ReadAccess:$XXXXX,$QQQQ(G)	0
$ERWETR,$OOPOPP	0
UpdateAccess:HELLO	0
ControlAccess:BYE	0
AlterAccess:$TTTT(X)	0
AccessNone:No	0

Is it possible to convert the following to below

System.Username.*@DLLLSLS	System.Username.*@DLLLSLS
Flying:ALL(UPDATE)	System.Username.*@DLLLSLS
ReadAccess:$XXXXX,$DDDD(G)	System.Username.*@DLLLSLS
UpdateAccess:HELLO	System.Username.*@DLLLSLS
ControlAccess:BYE	System.Username.*@DLLLSLS
AlterAccess:$XXXX(X)	System.Username.*@DLLLSLS
AccessNone:No	System.Username.*@DLLLSLS
	System.Username.*@DLLLSLS
System.Username.*@XXXX	System.Username.*@XXXX
Flying:FEW(UPDATE)	System.Username.*@XXXX
ReadAccess:$XXXXX,$QQQQ(G)	System.Username.*@XXXX
$ERWETR,$OOPOPP	System.Username.*@XXXX
UpdateAccess:HELLO	System.Username.*@XXXX
ControlAccess:BYE	System.Username.*@XXXX
AlterAccess:$TTTT(X)	System.Username.*@XXXX
AccessNone:No	System.Username.*@XXXX

[Qiu · Accepted solution]

@walkingbird 
I think this is a typical application of Multi-Row Formula tool.

[walkingbird]

Thank You!! i did not know that we could apply it on output itself.

[Qiu]

@walkingbird 
Glad to help.