•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Converting this data input into a flat table
I have been tasked to start a stock take sheet and they have requested that the input is in the shape of the shelving to allow the older stores person to easily fill out but how do i convert this data hit a bit of a road block and dont want to manual reference every cell due to having 600 slots to do. Any help be great!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#Excel compatibility
#stock take
#flat table
#sheet
#shelving
#data input
#manual reference
#converting data
#cell reference
#stores person
#data
#input shape
#600 slots