Convert 1 Excel column into 3 balanced columns to paste into FM

[LGLists]

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-bounces at 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-frameusers.com/attachments/20130825/95cb2242/attachment.htm>