Marco Cruz 2 Posted February 22, 2021 Share Posted February 22, 2021 Hi there, Can you guys please help me I am trying to create a new calculated column that outputsall the user's vehicle. I do not think ifand case when method would consideringthey would only lookwhat's in the row.I used excel to show how the output should look like, please see image below: Thanks! Marco Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 22, 2021 Share Posted February 22, 2021 Your picture seems broken, can you try again Link to comment Share on other sites More sharing options...
Marco Cruz 2 Posted February 23, 2021 Author Share Posted February 23, 2021 Hi sorry about that! I want to be the output to be the column in green. Thanks! Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 23, 2021 Share Posted February 23, 2021 Try this calculated column: UniqueConcatenate([Vehicle]) Over ([user]) Link to comment Share on other sites More sharing options...
Marco Cruz 2 Posted February 24, 2021 Author Share Posted February 24, 2021 Hi Gaia Thank you so much! it works Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now