Cross tab/transpose tool

[stataltgee]

I have a table like this. 

I want the above table in following format.

[Qiu]

@stataltgee 
Your data looks very familar to me 😁

[flying008 · Accepted solution]

Hi, @stataltgee 

FYI.

The above flow has good compatibility with more situation like @gawa .

Input
.	Operating	Design
Pressure	kg/cm2 g	kg/cm2 g
	0.1	3.5/F.V
Temperature	C	C
	40	70
Flow	m3/h	m3/h
	100	110
Output
Operating Temperature (C)	Operating Pressure (kg/cm2 g)	Operating Flow (m3/h)	Design Temperature (C)	Design Pressure (kg/cm2 g)	Design Flow (m3/h)
40	0.1	100	70	3.5/F.V	110

[gawa]

@stataltgee 

Please try the attached workflow. I imagine you are having more parameter not only pressure and temperature. My WF can cater for those scenario. Please check it out.

[stataltgee]

 

The multi-row formula is not working. I forgot to mention there is a blank row in between in the input data. 

[stataltgee]

This solution is somehow working. I forgot to mention there is a blank row present. Can you please let me know the solution for this.

[stataltgee]

I forgot to mention there is a blank row present. Can you please let me know the solution for this.

[gawa]

@stataltgee Right after Input tool, put Data Cleansing tool, and remove null rows.

[stataltgee]

If I apply data cleansing tool, the records change like above.

[gawa · Accepted solution]

@stataltgee It should be because of AMP engine. Turn off AMP engine.

BTW, with my WH shared int the above post, it works well even having null rows. Please check it first.