Put column data in rows grouped by ID

Difficult to put this in a question, but this is what I mean:

This is my data:
ID  DATA1  DATA2  DATA3  DATA4
1   yes    yes           yes
2          yes    yes
3   yes                  yes

What I like to get:

ID1
- DATA1
- DATA2
- DATA4
ID2
- DATA2
- DATA3
ID3
- DATA1
- DATA4

Anyone knows what query or formula I can use for this?