Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transpose Question

mzsweetumz
8 - Asteroid
‎05-22-2023 08:19 AM

Hello,

 

I am comparing full names within multiple datasets and would like to have each dataset as one column, and highlight the row numbers where the full names appeared in separated by commas:

 

mzsweetumz_0-1684768712422.png

 

 

Example: The name 'Taylor Swift' appears in Report 2 in rows 5, 7, 8

 

Thank you!!

 

 

Labels:
Reply
0 Likes
1 REPLY 1
Luke_C
17 - Castor
17 - Castor
‎05-22-2023 08:29 AM

Do you have an example of the raw data?

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All