Duplicating the values in column

Happy_20

Hi

I need to create a table like;

Node Name | Type | Used | Free |

AUH-AUQ-A7Q | A | 10 | 50
| B | 56 | 78
AUH-A2W-A7W | A | 6 | 7
| B | 34 | 45

By "Supress Duplicates", I can achieve the "Node Name" column. But how to achieve the repeated value "A" &"B" in the "Type" column.

Please guide me.

thuston

Not sure I understand. Can you post a screenshot of your report?

Sorting the table and adding Suppress Duplicates on the Type Column should hide duplicate As and Bs.