Newsfeed
Can I arrange my data in columns instead of in rows?
Editing your Excel spreadsheets can become inconvenient when you have a lot of data fields to merge. Some Merge users regularly work with dozens of fields, and have to scroll back and forth constantly to edit their data.
Merge updated April 2009
To make things simpler, we've updated Merge.
Merge now allows you to arrange your data by rows (as before) or by columns. This can make it much simpler to maintain large, complex data sheets.
The default is still one record per row with field names in the first row, but you can put your fieldnames in the leftmost column and arrange your data so that each record is in a different column. To let Merge know that you've arranged your records by columns instead of by rows, you need to add this to the [PPTMerge] section of PPTools.INI:
RotateData=YES
This is the default way you'd lay out your data
| :firstname: | :lastname: |
| Steve | Rindsberg |
| Brian | Reilly |
| Davey | Jones |
But with RotateData=YES in the PPTools.INI file, you can set it up like this:
| :firstname: | Steve | Brian | Davey |
| :lastname: | Rindsberg | Reilly | Jones |
You'll probably find that it's much easier to enter and edit large amounts of data when you "rotate" it like this.
[Previous] [Home] [Next]