using columns as records?

[Mia A]

I know that Excel automatically selects the ROW as a record when you are using it as a source for merging into Word. Is it possible to make the COLUMN the record?

Aase in point: I have monthly statistics in an Excel spreadsheet. Column A lists the description title; Column B lists Week 1 figures; Column C lists Week 2 figures, etc. I want to merge this information into Word, but I want to pull the stats by week, which was sorted in columns not rows.

Thanks to anyone who responds,
Mia

 

[dcardno]

I am not sure if you can do this automatically - have you thought about using a "Transpose" function to get the data into row-record fromat, and them merging that into word?