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

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.
Similar Threads
  1. Ralf Hildebrandt

    type conversion and concatenation

    Ralf Hildebrandt, Jul 23, 2003, in forum: VHDL
    Replies:
    3
    Views:
    7,377
  2. walala
    Replies:
    3
    Views:
    5,418
    walala
    Sep 18, 2003
  3. bigdipper_gary
    Replies:
    1
    Views:
    1,192
    Mike Treseler
    Jan 5, 2004
  4. pandora

    vector concatenation

    pandora, Apr 3, 2004, in forum: VHDL
    Replies:
    8
    Views:
    24,427
    vipinlal
    Mar 26, 2010
  5. Chad

    generic concatenation

    Chad, Aug 25, 2004, in forum: VHDL
    Replies:
    4
    Views:
    1,138
  6. Mohammed  khader
    Replies:
    1
    Views:
    2,714
    Alan Fitch
    Nov 1, 2004
  7. Analog_Guy

    Concatenation in PROCEDURE call

    Analog_Guy, Feb 14, 2005, in forum: VHDL
    Replies:
    1
    Views:
    1,032
    Paul Uiterlinden
    Feb 15, 2005
  8. G Kannan
    Replies:
    1
    Views:
    1,750
    Eric J. Roode
    Oct 11, 2003
Loading...