List data base having one field as title

Hey, guys. What's up?

I've been trying to create a list, with formulas, based on a table (data base). One of the fields of the table must be used as a title, separating records related to it.

I've attached my spreadsheet for a better explanation. You'll see I've already come across something (sheets Test1 and Test2), however it's still not exactly what I really need.

Please, could you help me do it?

Obs.: For particular reasons, I can not use VBA in this file, unfortunately. I must use formulas only. That's what's driving me nuts!

Thanks in advance for your attention.

Bruno

Fill K7 manually
In K8,

Please Login or Register  to view this content.

In L8

Please Login or Register  to view this content.

Then drag down both

JeteMc, I get your point and I appreciate your help, however I can't really use your formula the way it is because the word "Client" is just an example I used for the sample file that I've attached here. In my real DB, there's no "Client", I mean, there are real names of clients. Same goes with equipments, models and etc. Anyway, thanks for your attention.

kvsrinivasamurthy, when I first saw the sheet you attached, I thought the problem had been solved; however if you pay close attention to it, you'll see that there are some records (equipments) missing in the list. Please, check it out yourself, if you can. Every first record of each client is missing. Moreover, the list must be totally automatic, so I can't really "type the first client" on the top of the list. But I appreciate your help anyway. We're getting close. Thank you very much.

JeteMc, your file worked. Very good!!! Thank you so much for your attention.

Excellent! This is really, really good. All my spreadsheets will have a different approach from now on. Thank you very much for helping me, JeteMc. I really appreciate it.