I have 2 report which i need to combine , then output as excel.
for example
Report1
Item01 Supplier1 price
Supplier2 price
Supplier3 price
Item02 Supplier1 price
Item03 Supplier2 price
Supplier3 price
Report2
Item01 Customer1 price
Item02
Item03 Customer2 price
Customer3 price
Customer4 Price
Result combine
Item01 Supplier1 price Customer1 Price
Supplier2 price
Supplier3 price
Item02 Supplier1 price
Item03 Supplier2 price Customer2 Price
Supplier3 price Customer3 Price
Customer4 Price
is this possible ? I try to do using excel but no luck