Turning a table

[Kjaer]

Can anyone help me with this one?

I have this

And want it this way with a change in the "art x". Here you only see 3 "art" but there are many more. So the next one will be 4-Art X and so on.

[atcodedog05]

Hi @Kjaer 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[Kjaer]

Hi

The big problem for me is that I want to merge a continuously number into the name

I hope this is better explained 🙂

[AngelosPachis · Accepted solution]

Hi @Kjaer ,

Here's one way you can do it

You first bring in a record id for each one of your company names, which will then be placed at the beginning of that field and later become your new column headers. You should transpose and cross tab the data to bring them in the correct format, and then bring back the correct column headers (because the cross tab tool tends to replace any special character with an _ )

Cheers,

Angelos

[g_tejoram]

I hope this helps

[jinaleya]

hey'

i also want to ask this question im facing this issue.... from last year you solved my issuue

[Kjaer]

Just what I needed. Thanks a lot.