Hello everyone,
We often have several industries selected for our vacancies. If I now have a report on closed vacancies and the Industries column there, I get three rows for a job if the job has three different industries. This duplication makes it difficult to evaluate something later in Excel. So my question is: Is there a way to display all industries in one cell? Or is it possible to create a separate column for each individual industry so that the vacancy does not appear more than once? (I hope the screenshot makes it clearer).
Maybe a expression?
Thank you!
The easiest way will be to group the Job title and vacancies columns. That way, those two columns would appear only once even if there are multiple industries. Another way is to use a repeater table (not 100% sure as haven't tried this in years) in the industries column. Another way is the way I like - Hand write your own SQL which will create a comma separated list of the Industries and put it in one column.
Quote from: cognostechie on 24 Jul 2024 12:12:14 PMThe easiest way will be to group the Job title and vacancies columns. That way, those two columns would appear only once even if there are multiple industries. Another way is to use a repeater table (not 100% sure as haven't tried this in years) in the industries column. Another way is the way I like - Hand write your own SQL which will create a comma separated list of the Industries and put it in one column.
Hello, thank you - just one question if I click on Vacancy title and then group and click on industry and group, everything still appears several times?
Group all columns except the Industry