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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ralf Hildebrandt

    type conversion and concatenation

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

    vector concatenation

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

    generic concatenation

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

    Concatenation in PROCEDURE call

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