Data matrix

[#1]

Hi, I want to show field data in matrix layout, that is, if i have this values in a filed: A1,A2,A3,A4,A5,A6,A7,A8,A9, I want to see:

A1	A4	A7
A2	A5	A8
A3	A6	A9

I get this associating fields row and column to each data, but if I apply a filter I get this result, for example:

A1	A4
	A5	A8
A3		A9

when I want:

A1	A5
A3	A8
A4	A9

Any idea?

[tresesco]

Not sure if understood you right. May be just changing the listbox presentation line :

Uncheck the 'single column', and re-size the listbox by pulling the border up.

[#3]

I thought about using a list box, but the field has repeated values and I want see all of them. I think I can't do this with a list box.

[tresesco]

I guess if you could explain your real scenario requirement a bit more with a sample would help.

[#5]

The real scenario is that I want to load weight data about items, and I want to show only this weights in a table, but 2 dimension table, not a column. I associated a row and column number to each weight and I with a pivot table, using this row and column as dimensions I get this, but if I filter, weights disappear on the table but it remains a gap:

The weight in row 1 and column 1 disappear when I select a filter, but I need to reorder weights in only one column, so my approach doesn't work.

I need another approach to getting show all weights, if possible in tabular form, and responsive to the filters.

I appreciate any advice

[tresesco]

Tab:

May be like:

Load

          Column1 as Weight,

          Row

From <>;

Concatenate   // this might not be required if you have all fields common in both table like here

Load

          Column2 as Weight,

          Row

From <>;