Cross tab/transpose tool

[Inactive User]

I have a table like this. 

I want the above table in following format.

[Qiu]

@Inactive User 
Your data looks very familar to me 😁

[flying008 · Accepted solution]

Hi, @Inactive User 

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]

@Inactive User 

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.

[Inactive User]

 

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

[Inactive User]

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.

[Inactive User]

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

[gawa]

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

[Inactive User]

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

[gawa · Accepted solution]

@Inactive User 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.