How to make from one line, several ms sql?

Question

Transact SQL

For example, there is an entry in the table
id task1 task2.........taskN
1 text1 text2.........textN
At the output I want to get
id numTask textTask
1 task1 text1
1 task2 text2
..... ...............................
1 taskN textN
Maybe it's easy and at the end of the day it doesn't cook, I'm waiting for help, the question is very urgent .

Answer 1

UNPIVOT