Query to list Company ID with Billing Period by number with date i

[Dave M]

I have currently in one table:

Company Number | Period Start | Period End
1 | x | y
1 | y +1 | z
and so on....(10,000 companies)

I would like to create a query that would make:

Company Number | Period End 1 | Period End 2 | Period 3
1 | y | z
| a
2 | c | d
| e

etc...

Any ideas?

 

[KARL DEWEY]

Search on 'Crosstab' query.

 

[Dave M]

Have done, but I cannot figure out how to change it from a date based header
to a number one...

 

[KARL DEWEY]

Post SQL of a select query and sample data.