Group column within worksheet

Hello,

 

In my Worksheet, they are multiple columns (Client name, Investment type 1, Investment type 2, Investment type 3...) and I would like to create a column called "Type of investment" retrieving "Investment type 1, 2, 3 etc". 
So when I select "type of Investment", it shows the different types, already existing in the worksheet.

 

Can you help me out?

 

Thanks!

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Is it possible to have multiple values. I.e. a value in 1, value in 2 etc? If so you will need to unpivot the date from columns to rows. I.e. the structure should be 

    Client Name, Type of Investment

    Acme Corp, Investment Type 1

    Acme Corp, Investment Type 2

    Acme Corp, Investment Type 3

    If you can only have one value then you could write a formula using If. I.e.

    If(Investment Type 1 <> '') then Investment Type 1 else If(Investment Type 2 <> '') then Investment Type 2 etc.

    Reply Like
  • Thanks for your answer! I have tried to create this formula, it doesn't work. Please see below an illustration of what I am trying to do. Thanks

    Reply Like
  • Looks like you are going to have to pivot the data, and create an investment type column

    Reply Like
  • Marc Price Ok thank you foryour answer!

    Reply Like
  • Yes agree. You need to unpivot the data. 

    Reply Like
Like Follow
  • 3 wk agoLast active
  • 5Replies
  • 14Views
  • 3 Following