Transpose logic

[susukavi]

Team,

Need your help in developing below logic in Alteryx.Thanks in advance.

I/P:

	City1	City2	City3	City4
	Chennai	Delhi	Mbi	Kolkata
Temp	35	23	30	31
Humidity	99	98	97	96
Airflow	55	66	66	66

O/p:

Temp	Chennai	35
Temp	Delhi	23
Humidity	Chennai	99
Humidity	Delhi	98
Airflow	Chennai	55
Airflow	Delhi	66

[KGT]

What have you tried? Do you have a workflow with your data in it?

This is a simple transpose and so if I was to build a workflow to show, it wouldn't match your data. You have blank rows on the Input and then no headers on the output and so cleansing the headers would be the bulk of it. Then there's 2 messages of back/forth... all for a one tool solution.

Transpose. All you need to do is remove the line that has City in it, and make the cities the headers.

[Genevieve]

Hi @susukavi 

Once you have transposed, separate the row which has the names of the cities before mapping them with a Find/Replace.

  

[aatalai]

@susukavi the attached workflow should do the trick, showed you 2 different methods, please let me know how you get on