I tried the query you referenced but that groups them by the value / item in column 1. Click into the box beside Transpose and then click on the OK button.
MsgBox "The table " & strSource & " doesn't exist." Step Three - From the Edit menu, select Paste Special. MsgBox "The table " & strTarget & " already exists." ' Begin with the second field, because the first field Set rstTarget = db.OpenRecordset(strTarget) ' Open the new table and fill the first field with Set fldNewField = tdfNewDef.CreateField(CStr(i + 1), dbText) Set tdfNewDef = db.CreateTableDef(strTarget) ' Create a field for each record in the original table. In the list of functions, select Transpose, and give the entire range from the source sheet that you wish to transpose Click OK - your data range. On the Formulas ribbon, select Insert Function and then specify All Functions in the dialog box. The features of this function are: It links the data to. Characteristics of the TRANSPOSE Function. Then, check the Transpose box and Press the OK button. You can select the All radio button under the Paste options. ' Create a new table to hold the transposed data. On your destination sheet, select an empty range with the correct number of columns and rows. You can use the Ctrl + Alt + V as keyboard shortcut or the Paste button in the Home tab. Set rstSource = db.OpenRecordset(strSource) This will open up the Editor, which allows us to edit the data. This can be done by selecting the respective data source from the Get & Transform Data section of the Excel data tab. Function Transposer(strSource As String, strTarget As String)ĭim rstSource As DAO.Recordset, rstTarget As DAO.Recordset Step 1: Load the required data onto the Power Query Editor.
0 kommentar(er)
