Get two column with value from another column

[mokrane_bob]

Hello,

It's simple what i want to do but i can't reach it.

I have this 

Now i want to have two columns which will be filled according to the colomn source.

If the type is Newsletter => this will be filled in the new column for Newsletter.
if the type is Enquête => this will be filled in the new column for Enquête

Thank you

[Arul · Accepted solution]

Hi @mokrane_bob ,

You have to do this applied steps in your edit queries.

Go to edit queries and then,

1.Duplicate that column

2.Promote first row as headers

3.Replace value for column 1

4.Replace value for column 2

Regards,

-Arul