# How to create a list starting from a matrix

**URL:** <https://forum.knime.com/t/how-to-create-a-list-starting-from-a-matrix/58070>\
**Category:** KNIME Analytics Platform\
**Created:** [January 3, 2023, 10:37am UTC](https://forum.knime.com/t/how-to-create-a-list-starting-from-a-matrix/58070 "2023-01-03T10:37:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pietro\_Zaza](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/f1d935/32.png) [@Pietro\_Zaza](https://forum.knime.com/u/Pietro_Zaza)\
**Post date:** [January 3, 2023, 10:37am UTC](https://forum.knime.com/t/how-to-create-a-list-starting-from-a-matrix/58070/1 "2023-01-03T10:37:22Z")

</div>

How can i pass from a Matrix a list?  
i tryed to use Unpivot node but it didnt works.  
any suggestion?

 ![Immagine 2023-01-03 113447](https://forum-cdn.knime.com/uploads/default/original/3X/3/f/3f9ee8e0f8a3a8480cc6a3fdc3f9f57cfeb874c3.png)  
Thanks

---

<div class="post-metadata">

**Author:** ![aworker](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aworker/32/36421_2.png) [@aworker](https://forum.knime.com/u/aworker)\
**Post date:** [January 3, 2023, 10:45am UTC](https://forum.knime.com/t/how-to-create-a-list-starting-from-a-matrix/58070/2 "2023-01-03T10:45:33Z")

</div>

Hi @Pietro_Zaza

It sounds like a job for the -Unpivoting- node:

> **[Unpivoting](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.unpivot2.Unpivot2NodeFactory)**
>
> This node rotates the selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corre…

If you “copy & paste” here the Matrix data in text format, we can provide you directly with the workflow that achieves the transformation.

Hope it helps.

Best  
Ael

---

<div class="post-metadata">

**Author:** ![Pietro\_Zaza](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/f1d935/32.png) [@Pietro\_Zaza](https://forum.knime.com/u/Pietro_Zaza)\
**Post date:** [January 3, 2023, 10:49am UTC](https://forum.knime.com/t/how-to-create-a-list-starting-from-a-matrix/58070/3 "2023-01-03T10:49:56Z")

</div>

[knime exercise.xlsx](https://forum.knime.com/uploads/short-url/yYch5NkE5JXp9OTM6fpjsSmwEu8.xlsx) (487.9 KB)  
here you have it  
thanks in advanced for the availability!

---

<div class="post-metadata">

**Author:** ![aworker](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aworker/32/36421_2.png) [@aworker](https://forum.knime.com/u/aworker)\
**Post date:** [January 3, 2023, 11:12am UTC](https://forum.knime.com/t/how-to-create-a-list-starting-from-a-matrix/58070/4 "2023-01-03T11:12:43Z")

</div>

@Pietro_Zaza Thanks for the data and my pleasure to help.

The following workflow provides with a possible solution based on the -Unpivoting- node:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/9/094b26a7233c0f3936610dfa38c264ee69dccba0.png)

And goes from the initial data:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/a/0a6ad4562c645399eabde89e86f544883c28458e.png)

to the following result:

![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/0/a04d7f332bf51940aeec512e2098ecfb126433c0.png)

> **[20230103 Pikairos How to create a list starting from a matrix – pikairos](https://hub.knime.com/pikairos/spaces/Public/latest/20230103%20Pikairos%20How%20to%20create%20a%20list%20starting%20from%20a%20matrix~zLAZip7I1RRmR0jB)**
>
> This workflow provides a solution to question asked in post #58070: How can i pass from a Matrix to a column format? The solution provided is based on the -Unp…

Hope it helps.

Best  
Ael