# GI results as Table

**URL:** <https://community.velixo.com/t/gi-results-as-table/26>\
**Category:** Q&A\
**Tags:** Acumatica\
**Created:** [September 26, 2023, 1:41pm UTC](https://community.velixo.com/t/gi-results-as-table/26 "2023-09-26T13:41:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathaniel\_Travis](https://community.velixo.com/letter_avatar_proxy/v4/letter/n/7ba0ec/32.png) [@Nathaniel\_Travis](https://community.velixo.com/u/Nathaniel_Travis)\
**Post date:** [September 26, 2023, 1:41pm UTC](https://community.velixo.com/t/gi-results-as-table/26/1 "2023-09-26T13:41:33Z")

</div>

I am working in a company with 2 tenants that we use a lot, two separate businesses, that for ME I look at closely together and consolidate.

I want to build a Prepaid reconciliation, I have done a GL to pull the data from each, and now I want to combine the results into a single table to pivot. But I can’t seem to achieve this, is there another route I should be taking here?

---

<div class="post-metadata">

**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\
**Post date:** [September 27, 2023, 9:02pm UTC](https://community.velixo.com/t/gi-results-as-table/26/2 "2023-09-27T21:02:09Z")

</div>

Have you considered using the Velixo COLLATE function to combine the two result sets?

---

<div class="post-metadata">

**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\
**Post date:** [September 27, 2023, 9:14pm UTC](https://community.velixo.com/t/gi-results-as-table/26/3 "2023-09-27T21:14:07Z")

</div>

Great suggestion Harry!

Nathaniel, to ensure you don’t have the column headers from your GI twice in the resulting table, I would suggest that you set the IncludeHeader argument of the =GI() function to true on only one of the inquiries.

I attached a quick sample for you that uses two different tenants. Note that if you want to have the tenant name as part of results (for filtering/grouping in your pivot), my suggestion is to add a formula-column in your GI that returns a value, ex: =‘Company1’ in a new column called Tenant.

To make sure your pivot table does expand based on number of rows, you need to use this technique: [Using Pivot Tables with your Velixo Generic Inquiry reports](https://helpacumatica.velixo.com/support/solutions/articles/153000017818-using-pivot-tables-with-your-velixo-generic-inquiry-reports)

[Sample multi-tenant GI.xlsx](https://community.velixo.com/uploads/short-url/ax9O1FxeJ2kKX6jJbQ2sITaGgwZ.xlsx) (1 MB)

---

<div class="post-metadata">

**Author:** ![Andres\_Hernandez](https://community.velixo.com/letter_avatar_proxy/v4/letter/a/45deac/32.png) [@Andres\_Hernandez](https://community.velixo.com/u/Andres_Hernandez)\
**Post date:** [December 6, 2023, 4:24am UTC](https://community.velixo.com/t/gi-results-as-table/26/4 "2023-12-06T04:24:20Z")

</div>

Try the function VStack in excel, the 1st array will be the GI for tenant 1 and then the second array will be the GI for tenant 2. After that you can create the pivot table.