Cross tab/transpose tool

unknown

I have a table like this.

I want the above table in following format.

Screenshot 2023-11-24 1117061.png

Transformation

Accepted answers

flying008

Hi, @Inactive User

FYI.

录制_2023_11_24_14_28_36_771.gif

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 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.

All comments

Qiu

@Inactive User
Your data looks very familar to me 😁

1124-gtadlimbekar.yxmd

flying008

Hi, @Inactive User

FYI.

录制_2023_11_24_14_28_36_771.gif

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.

1212606_gawa.yxmd

unknown

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

unknown

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.

unknown

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.

unknown

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

gawa

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335