N
NatChat
Hi there,
I have run out of ideas on this one and now I've lost my fresh morning mind,
so any help would be much appreciated.
I have a list of garments and each style has a different number of sizes in
its size range from a minimum of 1 available size to a maximum of 24
available sizes, so I have 24 columns for sizes.
I want to concatenate the available sizes for each style separated by a
comma and a space.
A simplified version of the data as it currently stands is like this:
A B C D E etc.....out to 24 columns
1 Stock Item Name Available Sizes
2 Stock Item A 8 10 12 14
3 Stock Item B S M L
4 Stock Item C OS
and the result I want in one column (single cell) is:
A B
1 Stock Item Name Available Sizes
2 Stock Item A 8, 10, 12, 14
3 Stock Item B S, M, L
4 Stock Item C OS
The problem when I use concatenate or "&" across the 24 columns is that I
end up with commas and spaces after the available sizes for all of the
remaining blank cells.
I can't use IF because I can't embed that many IF statements in the one
formula.
Hope this makes sense. Thanks.
I have run out of ideas on this one and now I've lost my fresh morning mind,
so any help would be much appreciated.
I have a list of garments and each style has a different number of sizes in
its size range from a minimum of 1 available size to a maximum of 24
available sizes, so I have 24 columns for sizes.
I want to concatenate the available sizes for each style separated by a
comma and a space.
A simplified version of the data as it currently stands is like this:
A B C D E etc.....out to 24 columns
1 Stock Item Name Available Sizes
2 Stock Item A 8 10 12 14
3 Stock Item B S M L
4 Stock Item C OS
and the result I want in one column (single cell) is:
A B
1 Stock Item Name Available Sizes
2 Stock Item A 8, 10, 12, 14
3 Stock Item B S, M, L
4 Stock Item C OS
The problem when I use concatenate or "&" across the 24 columns is that I
end up with commas and spaces after the available sizes for all of the
remaining blank cells.
I can't use IF because I can't embed that many IF statements in the one
formula.
Hope this makes sense. Thanks.