# Merge some cells in the report

**URL:** <https://forum.inductiveautomation.com/t/merge-some-cells-in-the-report/106293>\
**Category:** Ignition\
**Tags:** vision, ignition81\
**Created:** [May 15, 2025, 11:50am UTC](https://forum.inductiveautomation.com/t/merge-some-cells-in-the-report/106293 "2025-05-15T11:50:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jchen](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jchen](https://forum.inductiveautomation.com/u/jchen)\
**Post date:** [May 15, 2025, 11:50am UTC](https://forum.inductiveautomation.com/t/merge-some-cells-in-the-report/106293/1 "2025-05-15T11:50:04Z")

</div>

Hi there, I'm currently working on the report module's table display. My data source (from python script not SQL) returns values in the following format:

 ![企业微信截图_17473093558514](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/1/81300b5a1910478827e7d4c333bf2ad06c88af69.png)  
This presentation doesn't look very user-friendly. Would it be possible to merge the "Shift" and "Date" cells to appear as shown below?  
 ![企业微信截图_17473093665040](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/a/9a6c596911f7d28798523b84e76697115f016fd0.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 15, 2025, 4:55pm UTC](https://forum.inductiveautomation.com/t/merge-some-cells-in-the-report/106293/2 "2025-05-15T16:55:57Z")

</div>

You might be able to achieve this with a crosstab table: [CrossTab and Simple Tables | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/crosstab-and-simple-tables#crosstab-table)

Though, to be honest, I don't think I've ever gotten a crosstab to work correctly. Another option would be to change to using 'unstructured' rows and manually setting up the text shapes within that row to make your hybrid rows - but that won't automatically scale to multiple duplicated rows.

---

<div class="post-metadata">

**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\
**Post date:** [May 15, 2025, 5:28pm UTC](https://forum.inductiveautomation.com/t/merge-some-cells-in-the-report/106293/3 "2025-05-15T17:28:25Z")

</div>

The default Table component does love to return rows.

If you are more so looking to group the rows more appropriately consider turning on Grouping:

> **[Grouping Data Inside of Tables | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/report-table/grouping-data-inside-of-tables)**
>
> Another important feature of tables is the ability to separate a single dataset into different categories or groups. When using a table in a report, you can group data in the table by a specific column. With Dataset Grouping, you can break tables...

If your data is that simple:

- Select Table
- Click the Grouping "+" button, add the Shift column
- Uncheck the Shift column Row \> Details checkbox
- From there the preview will have them grouping which may be more along the lines of what you're going for:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/6/f69875a14e9890ca833fe1096314ac2abf826e1d.png)

---

<div class="post-metadata">

**Author:** ![jchen](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jchen](https://forum.inductiveautomation.com/u/jchen)\
**Post date:** [May 16, 2025, 5:25am UTC](https://forum.inductiveautomation.com/t/merge-some-cells-in-the-report/106293/4 "2025-05-16T05:25:44Z")

</div>

Thanks for all the suggestions.  
Finally got something like this, use script to blank out the duplicate data and use the table row versioning to hide either the top or bottom border.

 ![企业微信截图_17473727115884](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/8/1890adfcce197b759c9ba6925ade658c846c8aee.png)  
But it doesn't center vertically for "Shift" and "Date" because the row is actually there, it's just not displayed.