Supress empty rows in basic table report

[Empower49]

Hello experts. I've read a lot of community posts, but still have questions. I used the arrange tool to create a basic table such as below:

Code    Description    Value

14         Color              Green

14         Name             Bob

14         Size               Small

15         Color              Red

15         Name         

15         Size              Medium

Questions:

1. How do I omit rows without data (such as "15" with missing "name") from the output?

2. Can I group the output on "code" so that each code is only listed once?

3. Can I add a blank row between each group?

Example below:

Code    Description    Value

14         Color              Green

             Name             Bob

             Size               Small

15         Color              Red

             Size              Medium

Thank you!

[CharlieS · Accepted solution]

I've attached a workflow that walks through the requested items. 

items 1 and 2 only require one tool each (Filter and Multi-Row Formula), but adding the blank row takes a few more steps as you can see. Basically you need to figure out how many rows you need to create and at what record position, then stack them together and sort them to that order. 

[Empower49 · Accepted solution]

Thank you very much for sharing your expertise! I appreciate you sharing the workflow and logic for the solution.