CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
ranjana raghav
ranjana raghav

Reputation: 13

How can we stack rows of data excluding blank under one header/column?

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

https://docs.google.com/spreadsheets/d/17pri0RnWP6dp86yYz_6T3rvNcU4XhvrCFGwmvaHmjHI/edit?usp=sharing

My data is

Data

Upvotes: 0

Views: 145

Answers (1)

Sebastian Smiley
Sebastian Smiley

Reputation: 1109

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")

Upvotes: 1

Related Questions