I need help.... I need to create an asset register, I have a sheet that contains summary data
My Columns are set out as follows: Site ID, Product 1 - Product 44
My Rows contain The Site ID and the number of units per Product
I need to take tis data and expand it so I can add each items serial number, I need an easy way to expand the sheet to allow me to address each item as an individual component against its site ID.
Is this possible or will I have to do manually
Help Article Resources
Check out the Formula Handbook template!