Macro Help to add new rows and fill data for specific columns

Good afternoon,

I am desperately trying to work out a faster method of manipulating the information I have on a spreadsheet to create a single list of items instead of a condensed table.

I have an asset table that lists multiple locations on the left, and asset types across the top. the table designates how many of each asset is at each location.
What I want, is a list of assets in a single column with the location the asset is in another, so you end up with location one repeated in one column 90 times and next to each cell for that location the asset type is listed.

I have attached an example table and example output. The actual asset list has 7000 odd assets and 300 odd locations so I want to be able use the macro on that spreadsheet and for it to continue down and across the table until all locations and assets have been completed and arranged into one single list.

any help with this would be muchly appreciated as you can imagine doing this by hand is going to take a long time

Originally Posted by mikeTRON

Are you familiar with PowerQuery? You can do this exact thing with a free Microsoft addin.

[It used to be called Data Explorer]
http://datapigtechnologies.com/blog/...data-explorer/

http://datapigtechnologies.com/blog/...data-explorer/
https://www.youtube.com/watch?v=CuNbvfXf28U

Thank you mike,
Unfortunately we have strict IT governance at work so I have to await IT approval to install the extension you suggested.
Is there any alternative way to complete the task using a VBA macro in case they do not allow its install or take a long time to get back to me?

thank you

Got it sorted. Power Query did half the work and a simple add rows macro finished it off.

thanks for that suggestion mike