# Unnest ## Using the Unnest transformation to flatten your data You can leverage the **Unnest** transformation to flatten your data. For instance, when you have multi-select options or comma-separated text values in your report, you can split your values into multiple rows. Let's look at an example to demonstrate how the Unnest function works. Consider a table that captures the orders placed. The investment products purchased by each customer are separated by commas.

An account manager may need to add details specific to each investment instrument, like an interest rate. They would need each product in a separate row to enter the rates as shown below. This is where the Unnest function can be used.

Let's look at this Planning sheet report that contains a multi-select data input field with benchmarks.

Planning sheet report with multi-select options

After importing the report into Infobridge and removing the Quarter column, let's apply the Unnest transformation. Choose Benchmark as the target column and comma as the delimiter.

Notice how each benchmark is flattened into a separate row. You can perform operations like creating a conditional column to set a rate for each benchmark.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.fabricplan.com/infobridge/9.-data-transformations/unnest.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.