transpose/pivot

peanut89

im prepping data for tableau for a visualisation and i need to pivot the annual revenue to make tableau read this better any tips...the current state is unreadable for tableau regarding the date format.

I would like to have the date in a column and corresponding revenue in the row beside... any ideas?

And yes there are other fields such as country, name product , as variables.

Thank you

Felipe_Ribeir0

Hi @peanut89 

You can adapt the attached workflow to do that.

Input

Output

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

Transpose.yxzp