Hi Arlette

I would like the output to be like this:
Column A - Column B - Column C - Column D
1000 - Data (text) - Data (text) - Data (text)
1001 - Data (text)
1002 - (empty)
1003 - Data (text) - Data (text)

The number of comments (data) varies from each uniqe ID, but at the moment I think there is 6 at the most.

Hope this helps.