• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Retrieve value for entire column

Ok here is the file. So I am appending the Direct POs query to the OTV RMA (which is the main query for transformation). Once I got to the Applied Step, Reordered Columns, I pulled up the Advanced Editor and pasted in the correct code, but I updated the table name and column. I am missing something. Thanks in advance!


  • tTransformedOTVRMAsandbox.xlsx
    19.4 KB · Views: 2
Cannot see your queries nor source data as the source data is resident on your computer and not in the spreadsheet you have posted.
Ok so how shall I set it up? Put all data sources in the same workbook? I did try to do that and then go to Get Data, From Other Sources, from Table/Range but it only points to the current worksheet.
I think I got it but I am sure I did it the hard way. Let's try this.


  • TransformedOTVRMAsandbox.xlsx
    37.8 KB · Views: 1
I ran across a simple answer using index feature with the following code:

Thank you for all your assistance with this, I do appreciate your help. Have a blessed weekend!