Transpose Data
- S'abonner au fil RSS
- Marquer le sujet comme nouveau
- Marquer le sujet comme lu
- Placer ce Sujet en tête de liste pour l'utilisateur actuel
- Marquer
- S'abonner
- Sourdine
- Page imprimable
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
Hi All,
I need to transpose data in a way I'm not sure how to do in Alteryx fully. See images below:
This is what my input file looks like current:
I need to transpose it so it looks like:
Currently I can get it where it's one column of data, but i need to show a column for each person's name. The person's name is also included in the output because I need to then output a separate excel based on their name (this I know how to do).
I also attached an excel to look at
- Étiquettes:
- Input
- Tips and Tricks
- Transformation
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
It's a little difficult to understand how you would get to the final output with the starting data. There's a lot of data in the final that is not contained in the initial data and vice versa. Can you explain more as to what you are wanting to do with the initial data ( I want to move this over here and this over there)?
Can you post what you have tried to do thus far in Alteryx so the Community can see your thought process?
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
Hey @znooredeen004
Transpose and Crosstab used to confuse me when I was just getting started.
the way I think of them now is that transpose goes from many columns down to a name-value pair; and cross-tab is like an Excel pivot table that gets you from name-value to columns.
So, in your case, given that you want a column for each person's name - this is a good use for cross-tab once you've already got it down to one column