Display (Not split) contents of a list across 2 rows for better visibility

[ConfusedMario]

I have tried to find the answer on forums and the net but search engines just bring me to articles explaining how to split the contents of a list into multiple columns; however this is not what I am trying to do. What I want to do is simple. I just want to display may list across two columns so I can see them better instead of having to scroll down. Basically I have a list of genres and I want to limit the amount of rows which the list is displayed in and once that limit is reached, the list starts on the adjacent column. Is this possible?

 

[pjmorris]

1. Turn on ‘Wrap Text’
2. Adjust column width to suit. To adjust column width simply drag the right hand side of the column header.
Alternative
2. Merge the relevant cells - though that can cause frustration later if you change or want to copy just a column of data.

HTH

 

[ConfusedMario]

Perhaps I was not clear. I know how to do the above, but I want to do is split the contents of a list that is in one column into 2 columns, so I can see all the terms in the two columns at once.

 

[pjmorris]

I think you need to post an example of you data and what you want it to look like. Without that it’s impossible to suggest a solution.

 

[Tom.Jones]

Perhaps I was not clear. I know how to do the above, but I want to do is split the contents of a list that is in one column into 2 columns, so I can see all the terms in the two columns at once.

Try:

=TEXTSPLIT(A2," ") change " " (blank) with your delimiter.

 

[Fluff]

Textsplit does not exist in xl2021, only 365.

 

[Tom.Jones]

Textsplit does not exist in xl2021, only 365.

Then....
TextToColumns

 

[FormR]

Hi, if I've understood correctly, assuming your long list is in the range A2:A1000 and the maximum number of rows you want to display per column is 40, then you could try something this to spread the results across as many columns as is necessary:

=LET(MR,40,FX,INDEX(A2:A1000,TRANSPOSE(SEQUENCE(ROUNDUP(COUNTA(A2:A1000)/MR,0),MR))),IF(FX="","",FX))

 

[Tom.Jones]

Try:

=TRANSPOSE(FILTERXML("<b><a>"&SUBSTITUTE(A1," ","</a><a>")&"</a></b>","//a"))

 

[Fluff]

@Tom.Jones I think you have misunderstood what the OP is asking for. He/She does not want to split a list/cell.