![]() ![]() Click on the drop down on the Date column > deselect ‘null’ from the list: Tip: If you want to reference the row above, then you could use Fill > Down to copy the data down to the next row. Select the new Description column > Transform tab > Fill > Up: We can now use the Fill Up tool to bring the descriptions up to the row above. ![]() Using the dialog box it’s easy to build a conditional if statement: The Date column contains a null value where there is a description, and we’ll use this for our logical test. If it contains the description, we’ll bring it across to the new column, otherwise we’ll leave it blank (i.e. We’ll use an ‘if’ statement to determine whether the row contains the transaction or the description. Note: Excel 20 users will go to the Power Query tab > From Table/Range. My data is formatted in an Excel Table called ‘SimpleTable’, so I’ll use the ‘From Table/Range’ connector of the Data tab of the ribbon: One way we can bring data form one row up to the row above is with the Fill Up tool. ![]() Referencing the Next Row in Power Query – Simple Table Option 1: Fill Up xlsx file please ensure your browser doesn't change the file extension on download. Excel for Customer Service Professionalsĭownload the Excel Workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |