> For the complete documentation index, see [llms.txt](https://resources.less.tech/less-tech/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://resources.less.tech/less-tech/modelling/action-guides/new-columns/split-columns.md).

# Split Columns

<figure><img src="/files/7gVTYNh1f8TxAXIdLkl8" alt=""><figcaption><p>The Split Columns Action</p></figcaption></figure>

This Action is similar to Excel's Text-to-Columns function. It can split columns from left or right to either columns (-> wide data set) or rows (-> long data set) by a delimiter (like a comma)

{% embed url="<https://www.loom.com/share/91d1a5649c024929aed2bd11b1c13167>" %}