Hi Team,
I need your help in creating a macro for anonymising data. The following steps will explain the step by step process of what the macro should be doing:
1. All the contents of each attribute (string) column should be anonymised in such a way that it should replace the real data with the header name. For example, if there is a country column with country names such as UK, US, India- then macro should replace the country names to Country_1, Country_2 and Country_3.
2. Similarly, it must recognise ID columns (for example- employee_ID) in the same manner as above.
3. For the measure/ value columns, we must randomise the numbers.
I'm attaching an excel file to showcase what result I would need from the macro for your reference. Please note that the macro should not be restricted to just this file and the columns mentioned in this file. There can be more/ less number of columns with different column names that the macro should be able to read.
Looking forward to your reply ASAP!
