Can you help me with a code to show the data in the list box in rows, not columns

The search code in the file shows the data in the form of rows
Is it possible to help by making the search show the data of one row, but in the form of groups below each other in the List Box?
For example, if there is a customer whose number is 1234, when searching for him, he brings me data from B1: B48
They appear in one row in the Listbox
Required :
To appear
from B1: B12 in a row and below it
from B13: B24 and below it
from B25: B36, then
from B37: B48
And if it is possible to show the sum of each column inside the list box with shorten code
Thank you very much
i posted it in another forums :
https://www.mrexcel.com/board/thread...lumns.1205345/

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)