hello,
i need (i think) a vba solution to my problem,
from time to time i receive an excel file that contains phone numbers from a a company that collects phone numbers from multiple sources,the file is compiled of one column (A) that contains ID numbers (Thousands) and several (about 30) more columns that contains phone/blank cells that belongs to the specific ID in column A (each ID is in a row),because every column (except A) represent different source of information its very common for some cells to be blank or contain duplicated phones.
what i need is a vba code that removes blank and duplicated cells (leaves the unique number),and than move the remaining phones closer to the ID column.
i uploaded an example to what i want to achieve, the file contains 2 sheets (one for the raw data and one ("fixed") for what the solution need to look like).
thanks in advance,
meir
i need (i think) a vba solution to my problem,
from time to time i receive an excel file that contains phone numbers from a a company that collects phone numbers from multiple sources,the file is compiled of one column (A) that contains ID numbers (Thousands) and several (about 30) more columns that contains phone/blank cells that belongs to the specific ID in column A (each ID is in a row),because every column (except A) represent different source of information its very common for some cells to be blank or contain duplicated phones.
what i need is a vba code that removes blank and duplicated cells (leaves the unique number),and than move the remaining phones closer to the ID column.
i uploaded an example to what i want to achieve, the file contains 2 sheets (one for the raw data and one ("fixed") for what the solution need to look like).
thanks in advance,
meir