4 Replies Latest reply: Jul 17, 2017 12:56 AM by praveen A RSS

    New column with specified cells

    Peter Kral

      Hi guys,

       

      I need your help with this. I have a table below as an example.

       

      YearBrand
      2016Apple
      2016Samsung
      2016Sony
      2016Nokia
      2017Apple
      2017Samsung
      2017Apple
      2017Apple
      2017Nokia
      2017Sony

       

      I need to create a new column with Apple cells only. Maybe like this. Please help me.

       

      YearNew column
      2016Apple
      2016-
      2016-
      2016-
      2017Apple
      2017-
      2017Apple
      2017Apple
      2017-
      2017-