Data Cleaning

[aidel_realkids]

Hi All,

I need help to simplify my data. I have managed to clean it up till this point (refer image)

I want the end result table to only be 3 columns:

RK CENTRE / EXT PROGRAMME(active student) / EXTRA CLASS(active student)

*the Ext Programme & Extra Class are duplicate names.

Thank you in advance.

[rfeigel]

Your desired outcome isn’t clear. What do you want in the output columns. There are no “RK Centre” in your example data. What does “the Ext Programme & Extra Class are duplicate names.” mean?