class SheetPivoter {

    static List<Cell> getDistinctValuesInSourceSheetColumn(Sheet sourceSheet, Integer columnNumber){

        List<Cell> result = new ArrayList<>();

        for (int i = SourceLayOut.VALUES_START_AT_ROWNUMBER; i <= sourceSheet.getLastRowNum(); i++){
            Row r = sourceSheet.getRow(i);
            Cell c = r.getCell(columnNumber);
            boolean found = false;
            for (Cell cell : result){
                if (PivotUtils.cellValueEquals(c, cell)){
                    found = true;
                    continue;
                }
            }
            if (!found){
                result.add(c);
            }
        }
        return result;
    }

}