Hi dear Experts,
In which way this can be done?
So to get unique values in column A, while values from B to be transposed in one cell, separated by ; .
I tried with array formula, but is braking due to huge number of data, therefore maybe VBA code could me more suitable?
Any help is much appreciated!!
In which way this can be done?
So to get unique values in column A, while values from B to be transposed in one cell, separated by ; .
I tried with array formula, but is braking due to huge number of data, therefore maybe VBA code could me more suitable?
Any help is much appreciated!!