7 Replies Latest reply on Jul 5, 2018 11:19 PM by Zhouyi Zhang

    Need to merge a column from a sheet without getting duplicate values

    Ejaaz Ahamed Shaik

      Hello everyone,

       

      Attached is a data source file which has 2 sheets named 'R856 People' and 'R856 Jobs'. Now, I need to plot a visualization which shows the number of available jobs and number of available people per a Job function type and zip code.

       

      Number of available jobs can be sorted out using the Placed column in 'R856 Jobs' as 'No'. Likewise number of available people can be sorted out using the Placed column in 'R856 People' as 'No'. Zipcode can be taken from the 'report to zip' column in 'R856 Jobs'.

       

      Can someone please help me in getting that visualization and also to explain me how to achieve that.

       

      Thanks,

      Ejaaz.