Move data to other row if contains rating value

Question

I am trying to move the value of review3 to reviews2 if reviews2 contains ratingValue. I am going to transpose them back to were row will be the column header and the reviews2 will be the value. I have tried doing if review3 is !empty then review2=reviews3 but all i get is 0.

PanPP · Accepted Answer

Hi @lbolin

I have provided a sample WF that adds the rating to review2 if ratingvalue is in the reviews2 column.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.