Retrieve value for entire column

[AlanSidman]

Anonymize your confidential data with dummy info. Keep your file to 10-15 records and lets see what happens.

 

[Kelly A]

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!

 

[AlanSidman]

Cannot see your queries nor source data as the source data is resident on your computer and not in the spreadsheet you have posted.

 

[Kelly A]

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.

 

[Kelly A]

I think I got it but I am sure I did it the hard way. Let's try this.

 

[Kelly A]

I ran across a simple answer using index feature with the following code:
=RefurbSo {1}[DOCUMENT NUMBER]

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

 

[AlanSidman]

Congrats. Hope this resolves all your issues.