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
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