- 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
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