Hello guys,

I need some help here.. I have 2 questions

1. I have 2 spreadsheets and i am trying to append the data(from spreadsheet2) to the end of data in rows into spreadsheet 1

Here is where I want it
http://screencast.com/t/nZnuenp97

Spreadsheet2
http://screencast.com/t/fkViEhGy0O

I can easily copy and paste from spread 1 to 2 but can't get it to paste at the end of the existing data in spread 1..


Question # 2

Is there any way to move data from the end of the rows to another place in the same row..
I want to move the numbers on the end to where the red arrows are pointing (Behind the word halco)
http://screencast.com/t/LOWccl3AbUq

Please advise..

Thanks, Dan