Back

If your email is not recognized and you believe it should be, please contact us.

  • You must be logged in to reply to this topic.Login

Table Formatting Issue not sure what to Use or how to start

Return to Member Forum

  • Author
    Posts
    • January 26, 2020 at 7:06 pm #1225298
      Sam Moening
      Member

      Hello-
      Let me try and explain this as best as I can w/o being able to show it.

      I am trying to set up a price sheet, right now it is in Excel and comes into InDesign like this small sample below, the actual spreadsheet is very large. Each line is its own row. Will explain what I need below.

      Black Spray Paint 80-888 $9.99 20 oz. aerosol can
      Black Spray Paint 80-888C $12.99 20 oz. aerosol can
      White Spray Paint 80-560 $8.99 16 oz. aerosol can
      White Spray Paint 80-560C $10.99 16 oz. aerosol can

      What I am looking to be able to do is have it set up like below. Lines 1 & 2 from above would be able to be combined into ONE line and the duplicate info of “black spray paint” & “20 oz. aerosol can” would be deleted.

      Black Spray Paint 80-888 $9.99 20 oz. aerosol can
      80-888C $12.99
      White Spray Paint 80-560 $8.99 16 oz. aerosol can
      80-560C $10.99

      So needless to say I have been plugging at this for awhile now and cannot figure out anything or how to even get started on this. Hoping someone out there has seen this before and can lead me in the correct direction.

      Thanks,
      Sam

    • January 26, 2020 at 7:07 pm #14323200
      Sam Moening
      Member

      This post did not keep the formatting like I typed it up. But is you look at what I have the example is 4 columns and if you look at it you should be able to see where it is broken up.

    • January 27, 2020 at 8:23 am #14323198
      David Blatner
      Keymaster

      Have you looked at my course “InDesign Essential Training” on LinkedIn Learning (Lynda.com)? I have a chapter in there about how to format tables, including merging cells, and so on. Diane Burns has a course there that goes into even more depth on what you can do with tables.

    • January 27, 2020 at 10:56 am #14323193
      Aaron Troia
      Participant

      You might also be able to use GREP to remove that information before you import. The Excel file would probably need to be converted to a CSV or TSV first, and then open it in a text editor like Sublime Text to do it.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.
Forum Ads