Hi Pornphop,
Excel won’t be the proper asset to use in order to achieve this type of list and display as we usually use filtering to discriminate elements for a “category” (generic word).
In your case, number of Companies may vary, same with number of details (may be 1 or 2, or more I guess) and the details.
Instead of Excel, I recommend you to use an json file.
I’ve set up a quick one that you can see here https://pastebin.com/raw/61w57Cdv
I’ve used http://jsoneditoronline.org/ to write it, and then hosted it on https://pastebin.com
Once it’s done, just fire your API Explorer, use the URL in it and create an Asset from the json file.
If you drag’n drop this asset on your scene and after a minute of layouting, you’ll end up with this :
which is exactly what you have on the #1 (left hand side) of your picture.
I’m sharing this small experience if you want to dig in.
Community-JSONStructure.zip (6.2 MB)
This sample will allow you to display every data. There is no filtering on JSON client side.
If you want to filter, Excel is the way to go, but I need more details on you exactly want as I don’t understand exactly.
What do you want to see in your experience, based on what criteria ?
All Companies for a specific Theme? Themes for one specific Company?
I could use more details.
Regards,
Alex.