I need to create a macro, that will attach attributes to a sku#. Example:
sku color height width casters material
98202 blue 10' 5' plastic
91505 red 11' 6' yes metal
I need the macro to display the following using the table above:
sku att name att value
98202 color blue
98202 height 10'
98202 width 5'
98202 material plastic
As you can see in the first table sku#98202 under casters there is no value. I need the macro to skip the empty cells and continue to the next attribute. The macro should not show empty cells.
Can anyone help. I tried in mysql but the way our database is structured, I'm not allowed to find the results I need.