Hi all,

I need to create a macro which from given table values will create list.
I have a table with data (sheet “Data”). The number Value from the “Data” sheet (D7:G27) I need to transfer to the “List” sheet in single column.
Also, I need in same line with the number value to show the corresponding value for “Category”, “Type”, Period” and “Super Market” (as shown in “List” sheet).
If there is a 0 value, this value not to be transfer to the “List sheet”.
For period, I need only the number value (instead of 12 month, to show 12).


If the original table in sheet “Data” is like this:

12 months 24 months
Lidl Tesco
Category Type
Fruit Apple 491 1086
Beans soybeans 1332 683
Fruit Melon 0 294



The final table in sheet “List” to be as shown below.

# Category Type Period Supermarket Value
1 Fruit Apple 12 Lidl 491.00
2 Beans Soybeans 12 Lidl 1332.00
3 Fruit Cherry 12 Lidl 961.00
4 Fruit Apple 24 Tesco 1086.00
5 Beans Soybeans 24 Tesco 683.00
6 Fruit Cherry 24 Tesco 294.00


Can anybody help me with this.
Thank you in advance.
Igor


Macro for sorting range value in row.xlsb