How to display 2 multi-value fields in a view

Hope someone could help with this problem I have:

There is a document with 2 multi-value fields. One has value “A,B,C,D” in it, and the other has “1,2,3” in it. In a value, I’d like to display these 2 fields in 2 columns, so it looks something like below:

C1 C2


A 1

B 2

C 3

C

I tried many different combinations of multi-value separator = New Line and/or Show multiple values as separate entries for the 2 columns, but none of them seem to achieve the expected result.

Can someone please help? Thanks.

Subject: like this

you can do it but are limited to 9 lines (or rows). Do NOT select “show multiple values as separate entries” for either column. On first tab in column prpoerties set “multi-value separator” to “New Line”. In view properties, 3rd tab, rows section set row height to maximum of 9 and select “shrink rows to content”. When I did this my view displayed exactly as you explained you wanted.