ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
communauté Alteryx IO MyAlteryx
alteryx Community
Search
annuler
Activer les suggestions
La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
Affichage des résultats de 
Rechercher plutôt 
Vouliez-vous dire : 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Rows to column

noopurjain
Astéroïde
‎02-06-2023 01:59 PM

Hello,

 

I have two columns in my data (Accounts and codes), For one account there are multiple codes. I need all the codes in single row with respect to one particular.  account. I have given the example in attached excel. How can I achieve this?

Alterys ques.xlsx
Étiquettes :
Répondre
0 Compliments
2 RÉPONSES 2
ShankerV
Castor
‎02-06-2023 02:04 PM

Hi @noopurjain 

 

Please find the expected solution.

ShankerV_0-1675721049755.png

 

Rows to column.yxmd
Répondre
0 Compliments
binu_acs
Polaris
‎02-06-2023 02:05 PM

@noopurjain One way of doing this

 

binuacs_0-1675721103581.png

 

Cross_Tab_060223_1.yxmd
Répondre
0 Compliments
Étiquettes
Auteurs des meilleures solutions
Tout afficher