I was wondering how to show only cells with values in a column. for instance i have information spread throughout a column say column b with multiple rows inbetween each cell. Say B5 = r and B12=3. i want column c to return only used cells in a row. for instance column c would read C1=r,C2=3.
thanks for your help.