I'm going to respond to my own post. This took so long to get to the list, that I asked Rick Quatro if he'd seen it (thinking I'd somehow missed it). He'd not seen, but great guy that he is, he took a few minutes to discuss my problem and came up with a simple solution that will work fine for my needs.
Here's what worked: 1. From the Excel worksheet with the list (all in one column), save as to a text (tab delimited) file. 2. Import the file into FM using the copy option, selecting Text as the type, then selecting a table format, make each para a cell, and three columns. (Wrote that from memory, but if someone else needs to do this, it should get you through the process). Worked well and even got the alpha list to go alpha across instead of down. Just what my client preferred. Thanks much, Rick!! ~~~~~~~~~~~~~~~~~~~~~~~~~ Linda G. Gallagher TechCom Plus, LLC lindag at techcomplus dot com <http://www.techcomplus.com/> www.techcomplus.com 303-450-9076 or 800-500-3144 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ _____ From: framers-boun...@lists.frameusers.com [mailto:framers-bounces at lists.frameusers.com] On Behalf Of LGLists Sent: Thursday, August 22, 2013 4:42 PM To: 'Post Framers' Subject: Convert 1 Excel column into 3 balanced columns to paste into FM Win 7 Excel 2003 FM 10 I have a list of 117 or so items that I get from a client as a single column in an Excel spreadsheet. I need to take that list and convert it to three balanced columns (maintaining the alpha sort) to paste into FM. I did it once manually, but the list keeps changing, so I'm looking for a way to easily convert to three columns, so I can just copy and paste it into FM whenever it changes. I'm think there's a way to do this in Excel, but my Excel knowledge could fit on the point of a pin (not even the head of the pin). Anyone know how to do that in Excel? ~~~~~~~~~~~~~~~~~~~~~~~~~ Linda G. Gallagher STC Fellow TechCom Plus, LLC - celebrating 20 years! lindag at techcomplus dot com www.techcomplus.com <http://www.techcomplus.com/> 303-450-9076 or 800-500-3144 Tutorials, "show me" demos, user guides, help, FrameMaker and WebWorks ePublisher templates ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.frameusers.com/pipermail/framers/attachments/20130825/95cb2242/attachment.html>
