Setting fields in tables

[#1]

Hi,

just a quick and I'm sure relatively simple question. I have a set of data that I am using, one of the columns is our financial period 1 -13, this is stored in a single column, what I would like to be able to do is create a table with the data set with columns 1-13 spread accross the top of the table as seperate columns and the data filled in beneath, how do I do this?

Many Thanks

Ben

[#2]

Use the CROSSTABLE Statement bevore the load.

Crosstable (period ,data,2) Load * from ex2.csv

It meens

2 Fiels will not turn

period is the name of the Column Heading (1..13)

data is the name of the content

Simple use the "table files"-assitant in the scripteditor

Have Fun! Regards

Dirk

[tabletuner · Accepted solution]

You can also create a pivot table in which you drag the period column to the top of the chart.

[johnw]

You can also create a straight table in which you select Horizontal on the Presentation tab of the properties.

[#5]

Hi, I'm sorry I can't fathom how to get these cross tables to work, If my spreadsheet looks like this:

Description	Period	Amount
Desc 1	1	100
Desc 2	3	10
Desc 3	4	20
Desc 4	5	25
Desc 5	7	32
Desc 6	8	54
Desc 7	10	98
Desc 8	11	78
Desc 9	13	45
Desc 10	9	98
Desc 11	2	45
Desc 12	6	12
Desc 13	11	32
Desc 14	13	45
Desc 15	12	78
Desc 16	3	12
Desc 17	5	32
Desc 18	6	45
Desc 19	8	844
Desc 20	7	98
Desc 21	9	54
Desc 22	10	21
Desc 23	11	2
Desc 24	5	5
Desc 25	6	84
Desc 26	8	98
Desc 27	9	88
Desc 28	3	54
Desc 29	4	21
Desc 30	2	954

And I want the periods to be transformed into a layout like this:

Description , Amount, Period 1,2,3,4,5,6,7,8,9,10,11,12,13 - how do I get there?

Thanks

Ben

[#6]

How do you find horizontal on the properties? When I create a standard table I cannot find any part that says horizontal - am I missing something?

[#7]

Ok, I misunderstand you.

Read the table it is it.

User a pivot table (chart) with dimension Period and and move the dimension clomn to the column headings with your. The blue arrow show where they are.

-Dirk

[johnw]

ben.shreeve wrote:How do you find horizontal on the properties? When I create a standard table I cannot find any part that says horizontal - am I missing something?

What do you mean by a "standard table"? What I meant was a "straight table", which is a form of chart. The "horizontal" checkbox is highlighted in black below:

[#9]

Hey thanks all, managed to get things sorted with the pivot table!