1 min readfrom 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!

https://preview.redd.it/onkbj0jr03jg1.png?width=1163&format=png&auto=webp&s=345e873b6637ec27ffbb46ba19c18186da6e9158

submitted by /u/TeacherAvailable8218
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article