I am currently working on generating questions in a tabular format involving 30 influencers, 30 products, and 10 brands. Since each of these categories can have multiple combinations, generating the questions in a straightforward way could result in approximately 9,000 unique questions.
To manage this complexity, I’ve started organizing the data in a table format. So far, I’ve successfully mapped the influencers and products. However, I am facing difficulty in displaying the associated brands for each selected product in the third row, arranged horizontally.
Attached below are my script files, along with two figures:
- Figure 1 illustrates the current table layout I’ve implemented.
- Figure 2 demonstrates the layout I aim to achieve, with brands displayed horizontally for each product.
I would greatly appreciate your assistance in resolving this issue. Thank you in advance for your support.
Influencer.xlsx (29.3 KB)