<tbody>
Date
Name
Amount
June 1
Bob
5
June 1
Bob
6
June 1
Doug
5
June 2
Bob
5
June 2
Doug
7
June 2
Doug
4
June 3
Bob
5
June 3
Bob
3
June 3
Doug
8
June 3
Doug
4
</tbody>
I'd like to pivot the above data with Names in the rows, Dates in the...
I have two issues I'm trying to solve
1: I have this:
<tbody>
Doug
Before
7
Doug
During
4
Doug
After
9
Jim
Before
3
Jim
During
7
Jim
After
4
Karen
Before
3
Karen
After
6
</tbody>
And need it to look like this
<tbody>
Name
Before
During
After
Doug
7
4
9
Jim
3
7
4
Karen
3...
So here is what I am trying to achieve
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
Person
Case#
Joe
17
Y
Bob
17
Bob
18
Y
Doug
17
Doug
18
Doug
19
Y
</tbody>
I want the third col to "trigger"...
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.