Hi Try this one
B2-1
C2-2
D2-3

in A2-
=A1&"
"&B1&"
"&C1

Note: between "" enter 'Alt+Enter'. you can just copy above function and
paste to A1. Once you done, active 'wrap text' from format cell menu.

if it is helpful, then pls rate


"Zeeshan Zaheer" wrote:

actually, I want to display multiple columns information within a cell in
multiple rows. normally we use ALT+Enter to write in multiple lines in a
cell, the same way I want a formula that could display the multiple columns
in a cell but in multiple line example:

1 A B C D

2 1 1 2 3
2
3
3