•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Returning values in horizontal data to vertical data
I an currently working on validating data for our SAP to F&O Microsoft Dynamics migration and I need to validate part pricing
One part multiple vendors (unique code via concat)
Xlookup to return each price per break qty
My issue is in the SAP file the data is displayed horizontally where one column i.ds quantity break and the other the price and so on. In the Dynamics file, it is displayed vertically, where the item repeats itself and the quantity break + prices appear per row. How can I get the right price from SAP file into the dynamics to then add a validation function if true than?
Thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#row zero
#no-code spreadsheet solutions
#Excel alternatives
#SAP
#Microsoft Dynamics
#data validation