Skip to main content
Solved

Attributes key and value to list

  • April 17, 2025
  • 3 replies
  • 73 views

hnahoulder
Contributor
Forum|alt.badge.img+2

Hello, 
I need your help. I'm looking for a workflow to transform my keys and values into a list. Here is an example:

I have this table:

Key Value
a 1
b 2
c 3
a 4
b 5
c 6
a 7
b 8
c 9

and I wanna transform it to

a b c
1 2 3
4 5 6
7 8 9

 

Thank you

Best answer by danilo_fme

Hi ​@hnahoulder ,

A possible way is shown as the screenshot below. See also the attached workspace example.

 

Awesome ​@takashi 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

takashi
Celebrity
  • April 17, 2025

Hi ​@hnahoulder ,

A possible way is shown as the screenshot below. See also the attached workspace example.

 


danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • Best Answer
  • April 17, 2025

Hi ​@hnahoulder ,

A possible way is shown as the screenshot below. See also the attached workspace example.

 

Awesome ​@takashi 


hnahoulder
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • April 18, 2025

Thank you for your help guys, it works perfectly