Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

transpose vertical column to horizontal

Hi,   I want to transpose a vertical column to horizontal, but problem is that vertical column is calculated and I have more than one company and product. Sample data and result is like following. ...
Need Help
AnalyticPulse's avatar
AnalyticPulse
Icon for Solution Sage rankSolution Sage
2 years ago

can you post your sample data and expected result separately 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Sample data is like this. M1 C/F and M2 C/F is the new column I want to get.

Reporting AttributeSales UnitAttributeForecast MonthThis Month FCRemainderM1 C/FM2 C/F
Car 1AAAMonth 011/1/20242   
Car 1AAAMonth 012/1/20241122
Car 1AAAMonth 021/1/20242   
Car 1AAAMonth 022/1/202412  
Car 1AAAMonth 031/1/20242   
Car 1AAAMonth 032/1/202472  
Car 2BBBMonth 011/1/20242   
Car 2BBBMonth 012/1/20240222
Car 2BBBMonth 021/1/20242   
Car 2BBBMonth 022/1/202412  
Car 2BBBMonth 031/1/20242   
Car 2BBBMonth 032/1/202472