Transpose Tool

[Neffri]

Hi,

I have a question if it's possible to Transpose columns: Q3 2020, Q4 2020, etc without duplicates in columns Numerator and Denominator?

Thank you

[atcodedog05]

Hi @Neffri ,

If you taking Numerator and Denominator as a key in transpose. Its not possible to not have duplicates.

Since each column get a row added with same key.

Hope this helps 🙂

[Neffri]

I need to have columns with Numerator and Denominator but also with Quarter and Value for them...

[atcodedog05 · Accepted solution]

Hi @Neffri 

If there is a calculation using Numerator and Denominator. Do the calculation first and then transpose maybe might help in calculation.

Other than No duplicates of key columns not possible. Should find a workaround.

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀