Hi all, need some help with transposing again and some formula I have my input data here: RegionMonthProduct CostTransportSavingsMktg costAdjustmentsAMERJan 34-123AMERFeb23-222AMERMar22051APACJan 65-122APACFeb72-0.534APACMar53062 and the output i would like is this (column 2 is formula based and i put it in algebra form): RegionMonthTypes of costsColumn 1Column 2AMERJan Product Costa AMERJan Transportba-bAMERJan Savingscb-cAMERJan Mktg costdc-dAMERJan Adjustmentse AMERFebProduct Costf AMERFebTransportgf-gAMERFebSavingshg-hAMERFebMktg costih-iAMERFebAdjustmentsj APACJan Product Cost APACJan Transport APACJan Savings APACJan Mktg cost APACJan Adjustments APACFebProduct Cost APACFebTransport APACFebSavings APACFebMktg cost APACFebAdjustments Thank you! Help_Transpose2.yxmd

Transposing data

Hi all, need some help with transposing again and some formula

I have my input data here:

and the output i would like is this (column 2 is formula based and i put it in algebra form):

Thank you!

I made 2 pattern solution.

Pattern 1 is simple solution. But if the column sort order is changed, it will be not work.

Pattern 2 is dynamic solution. If column order is changed, it will work well.

I made 2 pattern solution.

Pattern 1 is simple solution. But if the column sort order is changed, it will be not work.

Pattern 2 is dynamic solution. If column order is changed, it will work well.

Here is my take on it.

Multi-row formula

IF [Name] IN ("Transport","Savings","Mktg cost") 
THEN [Row-1:Value]-[Value]
ELSE Null()
ENDIF

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

@AkimasaKajitani @atcodedog05 i prefer the more dynamic solution, thank you both for your help!