Here is the link. I want to show three different types of particulars under one column with repetition of customer IDs on Google Sheets. Here is the link of the sample data

CodePudding user response：

The following formula should produce the behaviour you desire:

=QUERY({A2:E;{A2:B,F2:H}},"select * where Col3 is not null order by Col1")