Link to home
Start Free TrialLog in
Avatar of maqskywalker
maqskywalker

asked on

copying horizontal cells values vertically in Excel

Hi experts,

I'm using excel. My spreadsheet looks like this:

User generated image
So if you notice cells D1, E1,F1 and G1

This is just a sample spreadsheet. In my actual spreadsheet I have like 300 columns.

Is there any easy way to select the values in D1, E1,F1 and G1 and then place them vertically.

So then,
the value of D1 would be placed in the blue cell A3
the value of E1 would be placed in the blue cell A4
the value of F1 would be placed in the blue cell A5
the value of G1 would be placed in the blue cell A6
ASKER CERTIFIED SOLUTION
Avatar of Shaun Kline
Shaun Kline
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of maqskywalker
maqskywalker

ASKER

thanks