hi, i have a problem to transpose from horizontal table to vertical table
here is TempTable
what should i do if i want to insert the data to table [01-01-TotalManPowerQty] ( in vertical format )
here is TempTable
04-00-OPU_DetailsID | Code | RateCategory | EqType | Desc | Spec | 01/07/2021 | 02/07/2021 | 03/07/2021 | 04/07/2021 | 05/07/2021 |
10 | ECT0045 | 12 | T8A | Mobile Crane with Operator & signalman | 45T | 3 | 2 | 4 | 4 | 4 |
what should i do if i want to insert the data to table [01-01-TotalManPowerQty] ( in vertical format )
04-00-OPU_DetailsID | Code | RateCategory | EqType | Desc | Spec | DateTAManpower | TotalManPowerQty |
10 | ECT0045 | 12 | T8A | Mobile Crane with Operator & signalman | 45T | 01/07/2021 | 3 |
11 | ECT0046 | 13 | T8A | Mobile Crane with Operator & signalman | 45T | 02/07/2021 | 2 |
12 | ECT0047 | 14 | T8A | Mobile Crane with Operator & signalman | 45T | 03/07/2021 | 4 |
13 | ECT0048 | 15 | T8A | Mobile Crane with Operator & signalman | 45T | 04/07/2021 | 4 |
14 | ECT0049 | 16 | T8A | Mobile Crane with Operator & signalman | 45T | 05/07/2021 | 4 |