Forum Discussion

natasha519's avatar
natasha519
Icon for Helper II rankHelper II
4 years ago
Solved

Multiple Rows based on Unique ID

I have one column with a unique ID and I want to create a new column with the following values (New, Used, Old) for each unique ID.    Current Table: Unique ID Year  123 2001 456 2008 ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi natasha519 

     

    Here is my solution which may be simpler. 

     

    First add a custom column from Add Column > Custom Column with the list {"New", "Used", "Old"}

     

    Then expand above custom column to New Rows. You will get the desired result. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi natasha519 

 

Here is my solution which may be simpler. 

 

First add a custom column from Add Column > Custom Column with the list {"New", "Used", "Old"}

 

Then expand above custom column to New Rows. You will get the desired result. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.