ExcelBanter - move data to a single cell and at the same same time filter the da

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - move data to a single cell and at the same same time filter the da (https://www.excelbanter.com/excel-discussion-misc-queries/20403-move-data-single-cell-same-same-time-filter-da.html)

Ann

move data to a single cell and at the same same time filter the da

I have a list of data as follows:
A1.0.0, A1.01
A2.0.0, A2.0.4,A1.0.0

Now i want to put all the values into one cell and at the same time make
sure there are no duplicate cells..

Any suggestion on how to write the macros..

THanks

Dave O

put all the values into one cell
Into one cell, or into one column?

All times are GMT +1. The time now is 06:59 PM.