•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Convert raw data to layout
hi there,
I would want to know if it's possible to convert "raw" data from a table (or multiple) from a sheet into a report with a fixed layout I'd have made (like a model for graphs) in an automated way, would be better if it could adapt to small changes like number of rows for example.
it would for example :
-transpose columns A to E but keep a unique value for each one out of a table, in separate rows - draw graphs of G and H knowing F - add a big title - insert constant data to draw limit lines
Excel 2016 for now
See pictures in comment
[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
#natural language processing for spreadsheets
#big data management in spreadsheets
#rows.com
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Excel compatibility
#automated anomaly detection
#financial modeling with spreadsheets
#raw data
#fixed layout
#Excel 2016
#automated way
#draw graphs
#transpose columns
#unique value
#report
#constant data