Code or Concatenation

Discussion in 'Databases' started by tina miller, Oct 28, 2016.

  1. tina miller

    tina miller

    Joined:
    Oct 28, 2016
    Messages:
    1
    Likes Received:
    0
    I am having a really hard time either trying to transpose a database where I have 4800 roughly rows now from rows to columns so I can concatenate in Excel or just concatenate in Excel from the get go with an extract from the database. I will upload an example of the file I have that is the data have and then what I need to do.

    I have tried pivot in SQL Server coding but that does not work because I have so many variances in the database. I thought maybe I could code it in Excel with some VB to say if column A appears x number of times anything in the rows concatenate. But then was like how on earth do I do that. I looks like the .pdf and the .txt do nothing so zipped my excel instead
     

    Attached Files:

    tina miller, Oct 28, 2016
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.