Find last cell in row and copy/paste contents into first column

[DebN]

Hello
Is there code/macro (I obviously have no idea about this) that would look at a datasheet by row and find the last cell in each row that has data in it and copy/paste that cell's data into column A.
For example if my data was something like the following image,
Initially, column A would be blank and then and if I ran such a magical macro, then it would look at each row starting with row 1 and paste the contents of E1 into the first column (A1)
Then it would look at the second row and paste the contents of G2 into cell A2.
Then it would look at the third row and paste the contents of C3 into cell A3
etc.....

You guys are amazing and I am hoping that you can help.
Thanks in advance!
Debbie

 

[Joe4]

Pick some arbitrary column you know you will never go past (I am using "Z" in this example).
Then, enter this in A1 and copy down:

=LOOKUP(2,1/(B1:Z1<>""),B1:Z1)

 

[DebN]

Pick some arbitrary column you know you will never go past (I am using "Z" in this example).
Then, enter this in A1 and copy down:

=LOOKUP(2,1/(B1:Z1<>""),B1:Z1)

You rock Joe4!!
Thanks so much!!

 

[Joe4]

You are welcome.
Glad I was able to help!