AnsweredAssumed Answered

simple table

Question asked by grabo on Mar 6, 2018
Latest reply on Mar 20, 2018 by grabo

I have a silly problem ... yet I have no idea how to do it. I illustrate him.

imagine a simple excel table:

 

item number 1
measure/color         - color1       - color2       - color 3       - .... color n
measure (a)            - price1 (a)  - price2 (a)  - price3 (a)  - pricen (a)
measure (b)            - price1 (b)  - price2 (b)  - price3 (b)  - price (b)
measure (n)            - price1 (n)  - price2 (n)  - price3 (n)  - price (n)

 

item number 2
measure/color         - color1       - color2       - color 3       - .... color n
measure (a)            - price1 (a)  - price2 (a)  - price3 (a)  - pricen (a)
measure (b)            - price1 (b)  - price2 (b)  - price3 (b)  - price (b)
measure (n)            - price1 (n)  - price2 (n)  - price3 (n)  - price (n)

 

item number n...

 

here ... lots of tables with different items. Some tables can have many colors, many sizes, others few. How do I manage this type of data?
I would like to display the tables as I see them in Excel with rows and columns that change according to the data contained.
there may be 3 keys:
pk_ article code
pk_ color
pk_ measures

Outcomes