How to transpose a table

[daniilgurin]

Hi everyone.

I have a following task.

Given a table, which is like:

Id	09.01.2017	under val/upper val	10.01.2017	under val/upper val
#1	333	14	250	9
Null	Null	19	Null	4
#2	589	11	57	12
Null	Null	55	Null	23

Totally, there are many columns with dates headers (~250 pc)

I need to make this table plain and get smt like this:

ID	Date	Under val	Upper val
1	09.01.2017	14	19
1	10.01.2017	9	4
1	...	...	...
2	09.01.2017	11	55
2	10.01.2017	12	23
2	...	...	...
...	...	...	...

Please help!

[ChrisHe · Accepted solution]

Hey @daniilgurin ,

I'm guessing there may be a simpler way than the way I came up with but it should be totally dynamic for however many columns, ID's or dates that you have! Check out my attached workflow - I've put in a bunch of documentation to help explain but let me know if you have any questions.  And please mark as a solution if this worked so others can find it!

-Chris

[OllieClarke]

Hi @daniilgurin 

I had a crack at this. My solution feels a bit overcooked, but it does work (assuming you only want the under/over values)

Let me know if that helps

Ollie

[OllieClarke]

Thought I was overcomplicating it. @ChrisHe has the answer you want

[fmvizcaino · Accepted solution]

Hi @daniilgurin ,

Great challenge you have there. 

Since I was already developing a solution, I went through and finalize it.

It is pretty fun to see all these different solutions for the same problem @OllieClarke , @ChrisHe .

Best,

Fernando V.

[daniilgurin]

Guys, thanks for your help!