TRANSFORM MATRIX INTO TABLE

Question

Good Morning. I took a table with distance data and it is in matrix format.I want to turn it into a table.There are 5,700 lines and 5,700 columns, in this format:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1100023&nbsp; &nbsp;1100452&nbsp; &nbsp;1100601 ...1100023&nbsp; &nbsp; 0,0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;144,5&nbsp; &nbsp; &nbsp; &nbsp; 69,11100452&nbsp; &nbsp; 145,0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 203.11100940&nbsp; &nbsp; 125,0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;262,5&nbsp; &nbsp; &nbsp; &nbsp; 187,1...I want it to stay like this&nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C1100023 1100023 0,01100023 1100452 144,51100023 1100601 69,11100452 1100023 145,01100452 1100452 0,01100452 1100601 203.11100940 1100023 125,0...Can you help me? Thanks. Patricia*Sorry for my bad English.

olafhelper · Answer

PATDINIZ&nbsp;, for this you can use the build-in function UNPIVOT, see&nbsp;Using PIVOT and UNPIVOT - SQL Server | Microsoft Learn

Forum Discussion

TRANSFORM MATRIX INTO TABLE

Share

Resources