Add value from an existing cell to a column

[Uppsala2609]

Hello Community, 

I'm a newbie to Alteryx. I have a file where vendor put invoice reference number on the top row. I want to add that invoice reference number to column A, and delete the top row. Would appreciate your help to create that workflow (example data as in attached image). Thank you!

[flying008 · Accepted solution]

Hi, @Uppsala2609 

FYI.

or

[Uppsala2609]

Thank you so much!!!

[jirikrecek]

Alternatively, I was able to do this as follows:

1. start import on line 1 and set first row contains data to Yes in your Input tool
   Since your 1st row has the Invoice ID and your 2nd row has the actual header names, you need both
2. Use Select tool to rename your 2 columns
3. Add Record ID tool
4. Add Filter tool to show only records with Record ID >2
5. Alternate route uses Sampling tool to pull the 1st row (Invoice ID)
6. Use Append Fields tool to join the actual data and the Invoice # column from Sampling tool
7. Rename and reorganize the columns as you wish
8. This will populate your Invoice # in a new column for every record