How to (quickly) multiply different rows by different weights?

[vmartyan]

Hello,

Let's say I have 2 rows with 5 data points each:
row 1: 1 2 3 4 5
row 2: -5 -4 -3 -2 -1

For row 1, weight is 0.5 and and for row 2, weight is 2. I'd like to be able to get to this:
weighted row 1: 0.5 1 1.5 2 2.5
weighted row 2: -10 -8 -6 -4 -2

How can I perform this operation quickly for hundreds of rows, each with a different weight?

Thank you.

[Glenn Kennedy]

Maybe:

=A1*$G1 copied across and dnown.

[vmartyan]

Perfect, thank you!

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.