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

Alteryx designer Discussions

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

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