# Formatting data

### In this section

* [Deduplicating data](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/deduplicating-data)
* [Filling cells from above](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/filling-cells-from-above)
* [Putting the first letter of every word in upper case](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/putting-first-letter-of-every-word-in-upper-case)
* [Changing the case to lower case](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/changing-case-to-lower-case)
* [Removing unnecessary blank spaces in text records](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/removing-unnecessary-blank-spaces-in-text-records)
* [Deleting multiple columns](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/deleting-multiple-columns)
* [Retrieving the first non empty value of several columns](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/retrieving-first-non-empty-value-of-several-columns)
* [Automatically formatting data based on examples](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/automatically-formatting-data-based-on-examples)