How to transform a table and use column headers as field values?

[HeinzWaescher]

Hi,

I would like to do a transformation like this:

Can you help how to achieve this?

Thanks in advance
Heinz

[somesoni2 · Accepted solution]

Try something like this

Your current search giving table 1 | eval temp=name."#".department | fields - name department | untable temp month project | rex field=temp "(?<name>.*)#(?<department>.*)" | table name department month project

[HeinzWaescher]

Awesome, thanks a lot!

[sundareshr]

Can you share the query for the first table

[HeinzWaescher]

Unfortunately the first table would be the result of a csv