Delete specific rows and join the corresponding rows together

[geeklarokcmie]

I have 50,000 records of data with two columns. I need to delete the respected rows and provide the below output

Fields	Info
type	manual
business	finance
application	alteryx
line	finance
tech	desktop
type	automated
business	hr
application	AWS
line	anuity
tech	cloud

Excepted Output:

Application

Alteryx

AWS

[binuacs]

@geeklarokcmie One way of doing this with the join tool

[geeklarokcmie]

I can't create a separate workbook and list all the 50000 applications that are unique.