maqskywalker
asked on
copying horizontal cells values vertically in Excel
Hi experts,
I'm using excel. My spreadsheet looks like this:
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
I'm using excel. My spreadsheet looks like this:
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER