Transpose Data in a column to rows in a different table

Transact-SQL
1

I have a table named tblRSDSSix when selecting all records the result is

RevBp Budget Mycolumn
ABC 100 01
DEF 200 02
GHI 1000 03
I want insert/update just one row in a table named TBLDATASETEIGHT whose columns are as follows:
COL01 COL02 COL03 COL04 COL05 COL06 COL07 COL08 COL09 COL10 COL11

I want to write a script / SP that will take the value of BUDGET and put it in the corresponding col so the result would be
COL01 COL02 COL03 COL04 COL05 COL06 COL07 COL08 COL09 COL10 COL11
100 200 1000

So basically the columns COL01,02,03... receive the data from column Budget where the mycolumn data is identified

01 goes to col01,02 goes to Col02, etc

2

Thanks for this information

3

You can do it with PIVOT:

Using PIVOT and UNPIVOT - SQL Server | Microsoft Learn