Can a column from a table be split up into multiple columns?

I have a table in SQL SERVER with two columns that look kinda like
this:
type: amount:
trav 2.00
spend 1.50
matrix 3.00
spend 5.25
spend 2.25
trav 3.15
When these columns get to the report, they need to be split as columns
of those three types:
trav spend matrix
2.00 1.50 3.00
3.15 5.25
2.25
Would I go to the Layout tab to create agregated functions
to separate this with functions there?
Thanks,
TrinityDid you try to use matrix instead of table?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"trint" <trinity.smith@.gmail.com> wrote in message
news:1105478740.066071.114760@.f14g2000cwb.googlegroups.com...
>I have a table in SQL SERVER with two columns that look kinda like
> this:
> type: amount:
> trav 2.00
> spend 1.50
> matrix 3.00
> spend 5.25
> spend 2.25
> trav 3.15
> When these columns get to the report, they need to be split as columns
> of those three types:
> trav spend matrix
> 2.00 1.50 3.00
> 3.15 5.25
> 2.25
> Would I go to the Layout tab to create agregated functions
> to separate this with functions there?
> Thanks,
> Trinity
>