Multiplying Column header with the row items

[kishorebgl]

Hi,

I would like to map each item in the row with the column header and the price for that item for the customer, similar to the below one, can you please help me, Kindly go through both the work sheets, i want the output in the rowitem view. is there any easier way i can do the same Thanks in Advance....

SKuID ItemName Customer Rate
11682 Item 1 Cust 1 312.56
11682 Item 1 Cust 2 411.27
11682 Item 1 Cust 3 411.27
11682 Item 1 Cust 4 411.27
11682 Item 1 Cust 5 329.02
11682 Item 1 Cust 6 296.11
11682 Item 1 Cust 7 267.33
11682 Item 1 Cust 8 246.76
11682 Item 1 Cust 9 226.2
11682 Item 1 Cust 10 226.2
11683 Item 2 Cust 1 304.34
11683 Item 2 Cust 2 427.72
11683 Item 2 Cust 3 427.72
11683 Item 2 Cust 4 427.72
11683 Item 2 Cust 5 342.18
11683 Item 2 Cust 6 307.96
11683 Item 2 Cust 7 278.02
11683 Item 2 Cust 8 256.63
11683 Item 2 Cust 9 235.25
11683 Item 2 Cust 10 235.25