Hi All,
I have the data of Product in Row A and its price in row B. Similarly Product in Row C and its price in row D. in Total having 3 list of products and prices. Maximum 10 entries user can enter in each row. I want all the products from those 3 rows in single row G and its price in H without including the blanks. Here is the expectation .
<tbody>
</tbody>
Can any one please help on this.
I have the data of Product in Row A and its price in row B. Similarly Product in Row C and its price in row D. in Total having 3 list of products and prices. Maximum 10 entries user can enter in each row. I want all the products from those 3 rows in single row G and its price in H without including the blanks. Here is the expectation .
A | B | C | D | E | F | G | H |
Product A | Price | Product A1 | Price | Product A2 | Price | Product A | Price of Product A |
Product B | Price | Product B1 | Price | Product B | Price of Product A | ||
Product C1 | Price | Product A1 | Price of Product A1 | ||||
Product B1 | Price of Product B1 | ||||||
Product C1 | Price of Product C1 | ||||||
Product A2 | Price of Product A2 |
<tbody>
</tbody>
Can any one please help on this.