How to seperate values from single column to another column depending on the "Main" Column.

[Anonymous]

Hello,

Need to separate the count and seconds values from column "C" to D and E" and depending on the column "A" and "B". Moreover the neglection of unwanted data with "blank". Need not to adjust the column "C"

The column "D" should stands for "Count Values" and Column "E" stands for "seconds values" and seconds should converted into hours.

Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please follow these steps:

1.Create a calculated column to get the count value.

D =

IF(

    [A]="count",[C])

2.Create a calculated column to get the sec value and convert it to hours.

E =

IF(

    [B] ="sec",[C]/3600)

3.The final result is shown below.

If this is not the result you expect, please provide a screenshot of the desired effect, in order to better help you solve the problem.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.