If column has a value present then convert it into an additional entry into a row

[HadiElmo]

I am working with insurance policies where we can have additional coverage premium represented by a variable (as shown in image below ending with PA). I want to represent the premium for PA as a separate row entry. The tricky part is I want the new entry to have all the same features (policy from date, policy to date, policy no, etc.) as the original row entry, just have the Gross Premium PA value as Gross Premium value. you can see below what I have and what I want.

Thanks in advance!

[DanM]

@HadiElmo 

You can accomplish this by using two Select Tools with two data streams. in one stream Uncheck your PA fields and in the other uncheck your non PA fields. Update your Subclass name with a Formula tool in the data stream with your PA information and then use the Union tool to put that data back together. You can then sort the data by policy and sub class.

[Paridhi_Agrawal]

Hi,

See if this workflow helps. I just took selected columns.

Thx