How to update particular row data from different row value.

[anonymous008_G]

Hi -  How do I Bond Futures row for Short and Long column with respective Short and Long data from sector column. The Order keeps changes, so i need something which would work even if order changes. 

Sector	Gross	Net	Short	Long
Bond Futures	100	200
Short	50	80	30
Long	70	90		20

Expected Output :-

Sector	Gross	Net	Short	Long
Bond Futures	100	200	30	20
Short	50	80	30
Long	70	90		20

[OTrieger]

@anonymous008_G 

Will the data going to have only 3 rows? The order of the headers will not impact Alteryx, as Alteryx deal with the names of the fields therefore the order will not matter.

[anonymous008_G]

@OTrieger - Bond Futures will always be there. however, Long and short keep changes dependning on the source data. Either Long or Short or Both can come in the report. 

[OTrieger · Accepted solution]

[OTrieger]

There are other ways to get it done, I was trying to keep it simple to show the steps how to get there. There are other ways to get there with less tools.

[anonymous008_G]

@OTrieger - can you please attach workflow.

[anonymous008_G]

@OTrieger - I am not able to figure out transpose and cross-tab configuration to get right data. Please assist with workflow. 

[OTrieger · Accepted solution]

[binuacs · Accepted solution]

@anonymous008_G another way

[OTrieger]

@binuacs 
Summarize tool will generate error when one of these fields will be missing, as you setting it as a required field.