How to make Column & Rows in One Cell

Hi, and welcome to the forum.

Since you've not shared a workbook that shows your typical data and the expected result we can only answer in general terms. We'll also have to assume that what you consider 'making many columns & rows in one cell' is what we think you mean.

So given data in A1:E10 in F1 enter

Formula:

Please Login or Register  to view this content.

Copy F1 down to F10.

Now in G1 enter

Formula:

Please Login or Register  to view this content.

If you have many columns and rows this will be impractical to do manually so you'll need a macro to do it for you.