I have a large data set that I will need to use, it is currently within Excel.
I need the ability to place into a horizontal format to use in an UPDATE statement.
Currently data looks as such
I need to be able to insert into SQL as follows
And yes I know the code is not easy..