community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Transposing Columns and Data Values

Asteroid

Hi All

 

I have a excel with the below data format

ABCD
123 NOIT
112USA FIN

 

i want to transpose the data set to:

A  123

B  USA

C NO

D IT

 

Basically the idea is to transpose the header and 1st data record . if a column has a null value then it needs to find the next record that has a value for that column. I am unsure how to do that.

 

Thanks

S

 

Alteryx
Alteryx

If you transpose the data, then filter out the Null() records (Can use something more encompassing like !IsEmpty(TRIM([Value])) in order to get empties as well). Then you can use the Unique Tool on the Name field to take the first value of each.

 

First_answer_transpose.png

Labels