Transpose and pivot columns?

[willemynjansen]

Hi all,

I have a table with the dates "above" the actual table. Like the image below

I want to have the dates in a column next to the columns customer id, name, last name and age. 

I have tried to transpose, unpivot and pivot the table, but it won't work.

Can someone help me?

Thanks!

[BA_Pete · Accepted solution]

Hi @willemynjansen ,

If the two dates ALWAYS appear in the first two rows of the table, then you can use the following as new custom column calculations:

// First date
= previousStepName[Column3]{0}

// Second date
= previousStepName[Column3]{1}

Pete

[willemynjansen]

Hi Pete,

It gives an error as below:

We cannot convert the value #date(2018, 1, 22) to type List.

Could you help me with this?

[BA_Pete]

Apologies. I forgot to add the reference to the name of your previous query step.

I've updated my original response to include this.

Pete

[willemynjansen]

Thank you very much, that did the trick!