> What I would like to do is automatically bend the data so I get it on a
> single line and the change in Months seperate into columns

> Customer Jan 09 Feb 09 Mar 09 Apr 09
> ABC Ltd    £100   £200    £300    £400

> I think Pivot Tables could be a solution but not really used them ,

> I didnt know which area to post this as the answer could be query, report or
> macro

> I wish to know if there is a way to push data to from top down to left to
> right

> example is , from an ODBC link I gather turnover figures for customer over
> months which by default exports as follows

> Customer Month Turnover
> ABC Ltd    Jan 09 £100
> ABC Ltd    Feb 09 £200
> ABC Ltd    Mar 09 £300
> ABC Ltd    Apr 09 £400

> What I would like to do is automatically bend the data so I get it on a
> single line and the change in Months seperate into columns

> Customer Jan 09 Feb 09 Mar 09 Apr 09
> ABC Ltd    £100   £200    £300    £400

> I think Pivot Tables could be a solution but not really used them ,

> Thanks in Advance

> Jai Cutmore

> Jai_Friday wrote:
>> Customer Month Turnover
>> ABC Ltd    Jan 09 £100
>> ABC Ltd    Feb 09 £200
>> ABC Ltd    Mar 09 £300
>> ABC Ltd    Apr 09 £400

>> What I would like to do is automatically bend the data so I get it on a
>> single line and the change in Months seperate into columns

>> Customer Jan 09 Feb 09 Mar 09 Apr 09 ABC Ltd    £100   £200    £300
>> £400

>> I think Pivot Tables could be a solution but not really used them ,
> Yes, you should use the pivot wizard, it is quite simple. Just give it a
> try.

> mfG
> --> stefan <--

>Customer Jan 09 Feb 09 Mar 09 Apr 09
>ABC Ltd    £100   £200    £300    £400

>I think Pivot Tables could be a solution but not really used them ,