How To Print The ListBox With Multiple Columns?

[#1]

Hello Qlixperts!

Requesting your attention to this issue:

How to print the list box that has multiple columns without disturbing the arrangement.

Upon printing, the listbox is printed in one-column-per-page format instead of 4 that appear on the screen. How can I go about to achieve the desired layout in print?

Note: Sample file attached.

Any help will be greatly appreciated.

Regards & Thanks,

-Khaled

[Gysbert_Wassenaar · Accepted solution]

Can't be done with a listbox afaik. Try a pivot table. See attached qvw.

[#3]

Gysbert Wassenaar

Thanks a million times. I knew you would suggest a way out

Without your recommended solution, I was stuck at 99.9%.

Thanks

Regards,

- Khaled.