Creating columns based off sub-rows

[jhwth]

I have an input table like below that is unformatted; essentially, there are sub-rows containing currency values:

Column 1	Column 2
Item 1
Currency 1	100
Currency 2	150
Currency 3	25
Item 2
Currency 1	500
Item 3
Currency 3	100
Currency 4	100

Is there a way to group column 1 so that Column 1 shows the items while the different currency types becomes new columns? Essentially, the output needs to be something like this:

Item	Currency 1	Currency 2	Currency 3	Currency 4
Item 1	100	150	25	0
Item 2	500	0	0	0
Item 3	0	0	100	100

[Clifford_Coon]

Hi,

You can use a multi-row formula, followed by a Transpose / Crosstab pair.

Example attached.