Code or Concatenation


Joined
Oct 28, 2016
Messages
1
Reaction score
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
 

Attachments

  • example.zip
    14 KB · Views: 266
Ad

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. After that, you can post your question and our members will help you out.

Ask a Question

Top