SQL Pivot function with a text file database within Excel

I'm more or less a beginner and we do not have access to SQL server/access at work so I have to design an app within Excel VBA and using a text file (CSV) to store the data.

I have no problem querying data, joining the CSV's, but I would like to use the SQL Pivot/Unpivot statement to transpose one of the columns into rows. I'm not sure if that functionality exists as I keep getting the error that there's a syntax error in my FROM clause.

Please Login or Register  to view this content.

My data currently looks like the top of the picture and I want it to look like the bottom.

ex.png

This is simple enough to do with a pivot table but I wanted the user to be able to type over the data.

Additionally, is there anyway to make it dynamic because there will be an unknown number of possible clients so the number of rows would need to expand.

thanks in advance