Skip navigation
Currently Being Moderated

Are there any tricks to cleaning up this table?

May 23, 2012 7:49 AM

I've been given files that have tables that look like this:

 

Header 1Header 2

1

2

3

4

5

apples

oranges

pears

bananas

tomatoes

 

Instead of creating a distinct row for each item, the previous designer used line returns in a single row.

 

Can anyone suggest quick/easy methods to change those line returns to real table rows like this?...

 

 

Header 1Header 2

1

apples

2

oranges

3

pears

4

bananas

5

tomatoes

 

 

Distinct rows are important because we need to shade some of the cells. The clueless designer drew shaded boxes behind the table to fake this cell shading.

 
Replies
  • Currently Being Moderated
    May 23, 2012 7:59 AM   in reply to Marian Driscoll

    Add enough rows to accomodate the data, then you have a lot of cut/paste ahead of you I'm afraid....

     
    |
    Mark as:
  • Currently Being Moderated
    May 23, 2012 8:37 AM   in reply to Marian Driscoll

    Is this too simple?  Convert table to text, so that each cell turns into a list; make each list into a separate table, add a column to one, and then paste the other table into the added column?

     

    David

     
    |
    Mark as:
  • Currently Being Moderated
    May 23, 2012 9:20 AM   in reply to David W. Goodrich

    Hmmm.

     

    When I tried to do that I got a bunch of paragraphs with one item up to the last line of the first cell, then a paragraph with two items separated by a tab, and a bunch more single item paragraphs. It didn't look to useful, though I suppose one could replace the tab with another paragraph break, then keep track of the stuff that goes in each column, but that still seems to me like it's going to involve a lot of copy/paste.

     
    |
    Mark as:
  • Currently Being Moderated
    May 23, 2012 10:28 AM   in reply to Marian Driscoll

    Sure -- I have a script to do exactly that. (But not at my home computer.)

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points