Hi There,
I need a way of transposing this data...12 columns, there will be about 200 rows of data...
<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>
First Name
Last Name
Region
Manager
Patch
Q1
Q2
Q3
Q4
Q5
Q6...
<tbody>
BEFORE
2017
Andy
500
Andy
800
Eddy
100
Eddy
300
John
1000
John
400
Todd
600
Taylor
1
Todd
600
AFTER
2017
2016
Andy
500
800
Eddy
100
300
John
1000
400
Taylor
0
1
Todd
600
600
</tbody>...
How can I merge/format 2017 and 2016 (BEFORE) together like the example at the bottom(AFTER). The only difference is that Taylor has zero for 2017. Thank you,
<tbody>
BEFORE
2017
2016
Andy
500
Andy
800
Eddy
100
Eddy
300
John
1000
John
400
Todd
600
Taylor
1...
I have a VLOOKUP formula that works on the first cell it is used. However, it fails on all subsequent rows.
This is my formula...in cell V2 where it works. Then when copied to V3 it fails.
=VLOOKUP(W2,'Engineering'!$C$2:$J$375,8,FALSE)
This is the formula I have in V3...
=VLOOKUP(W3,'OSP...
Greetings all,
I have a table in Access 2013 that look like this:
<tbody>
Child
Pet1
Pet2
Pet3
Pet4
Timmy
Cat
Dog
Bird
Rabbit
Jimmy
Dog
Jack
Cat
Dog
Bobby
Cat
Rabbit
Todd
Dog
Bird
</tbody>
But what I would like is a table that looks like this...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.