Singular Row into a Column

[missteran]

I have somewhat of an odd question but trying to see if alteryx can do this. I have a data set with rows of deal names, followed by the type of deals these are considered. I would like to make that singular row that captures types of deals into a column instead. Please see what i mean below before and after.

Before:

Book	Deal Name	Manager	Exposure	Utilization
ABCD	Melissa Deal	Stuart	$100	$50
EFGH	Stephanie Deal	Owl	$100	$75
EFGH	John Deal	Gold	$100	$75
	Type of Deal: Secured Loan		$300	$200
YZKW	Erica Deal	Ares	$200	$150
POFD	Kaitlyn Deal	Oak	$150	$75
POFD	Joshua Deal	Apollo	$150	$75
HWQK	Frank Deal	Silver	$200	$100
	Type of Deal: Collateral Loan Obligation		$700	$400

After - the Deal type is now a column and no longer a singular row

Book	Deal Name	Manager	Deal type	Exposure	Utilization
ABCD	Melissa Deal	Stuart	Secured Loan	$100	$50
EFGH	Stephanie Deal	Owl	Secured Loan	$100	$75
EFGH	John Deal	Gold	Secured Loan	$100	$75
YZKW	Erica Deal	Ares	Collateral Loan Obligation	$200	$150
POFD	Kaitlyn Deal	Oak	Collateral Loan Obligation	$150	$75
POFD	Joshua Deal	Apollo	Collateral Loan Obligation	$150	$75
HWQK	Frank Deal	Silver	Collateral Loan Obligation	$200	$100

[nagakavyasri]

@missteran One way of doing this:

[Suresh_batchu · Accepted solution]

I Always choose to Multi row field tool to iterate though other records , Mark as resolved if this resolves your data 

[flying008]

Hi, @missteran 

Another way for you:

IIF(IsEmpty([Row-1:Book]) && IsEmpty([Row-1:Manager]), [Row-1:ID] + 1, [Row-1:ID])

REGEX_Replace([Deal type], '^.*:\s*', '')

or 

Trim(Substring([Deal type],FindString([Deal type], ':') + 1))