@Zac_Soh if you have them in a data table , then Use linq query to get all the keywords that contains “Keyword”
now you have DT1 → which has all keywords text
On the main Datatable , again use linq to get all values except the Keyword
now you have DT2–> which do not have keyword text
Now merge Both using merge activity , Source will be DT2 and Destination will be DT1
Like this all words contains Keyword will be at top and remaining words at bottom
@shanmukh_pothamsetty
Thanks for the quick reply, is there any other way beside splitting and merging? I tried merging but it messed up my format as some of the first few rows are empty, the data table comes from a pivot table