Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Insert Custom Column Into Table Power. Click on Transform data to open query editor window. So far so good.
Here are the steps to use columns from different tables. I can add a table to my spreadsheet and have 2 columns called col1col2 - and that all works correctly. I can add a worksheet to my spreadsheet and can get the worksheet to have the order number as the name of the worksheet.
The Custom Column.
Click or tap an existing table or Create a new table Add a new column to your table by clicking Add column. From the Add Column tab on the ribbon select Custom Column. For 6 of these columns projects are selected from tables of company-wide projects via dropdown menus. Enter a new column name.