Hi again forum
Grateful of some advice on a formula that has me stumped
I have data (from a large and changeable source) organised in a pivot
It looks like the table below
Pine 2.75M £50.50
Cedar 2.70M £45.00
Cedar 3.50M £35.00
Oak 2.75M £25.00
Ash 2.25M £75.00
Ash 5.00M £80.00
Ash 3.75M £90.00
Beech 4.25M £55.00
Maple 1.50M £45.00
The number of rows for each wood varies depending on entries in data
I need to be able to concatenate into single rows by wood types
So the multiple rows of M and £ data are concatenated into a table similar to shown below
Pine 2.75M,£50.00
Cedar 2.70M,£45.00,3.50M,£35.00
Oak 2.75M,£25.00
Ash 2.25M,£75.00,5.00M,£80.00,3.75M,£90.00
Beech 4.25M,£55.00
Maple 1.50M,£45.00
Grateful if someone could suggest a formula please
Thanks in advance D
Bookmarks