> 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

Split columns to rows or columns by a delimiter

<figure><img src="https://1596277999-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaSJL6Od4KuV8hrdCZbXp%2Fuploads%2FcNw1jJrN3uelDhLb581h%2Fanimation_500_labnmtjs.gif?alt=media&amp;token=4c79287b-a934-428b-a2f1-8ac31ad1e7b7" 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>" %}