How to Split Rows in Excel BI Publisher Output (Nested Rows Inside One Row)

Sure, here's a more polished version of your message:

Hello Community,

I am working on a scenario where I need to display data in multiple rows within a single row in an Excel output. The data consists of an RFQ with multiple lines and multiple suppliers. The goal is to display all this information in one row for the RFQ, but the lines and suppliers should be split across multiple rows as needed.

like in the screenshot

the RFQ have a large number of columns , making it difficult to manage in an RTF format. The output must be in Excel due to the large number of rows.