Thank you for your time.
I have a table that shows a Date, a Part Number, and a Price.
It's a cumulative table. So there are part numbers that have multiple different prices.
Column D shows the date.
Column I shows the part number.
Column J shows the price.
I would like to create a pivot table (or whatever...doesn't have to be a pivot table) that pulls out each part number and to the right of it, show the different prices and their corresponding dates.
Here's what my data looks like:
Sheet1
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 49px;"><col style="width: 35px;"><col style="width: 46px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 49px;"><col style="width: 93px;"><col style="width: 37px;"><col style="width: 105px;"><col style="width: 68px;"><col style="width: 56px;"><col style="width: 56px;"><col style="width: 21px;"><col style="width: 32px;"><col style="width: 19px;"><col style="width: 42px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
And here's what I'd like my summary table to look like:
Sheet1
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 105px;"><col style="width: 68px;"><col style="width: 56px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
I have a table that shows a Date, a Part Number, and a Price.
It's a cumulative table. So there are part numbers that have multiple different prices.
Column D shows the date.
Column I shows the part number.
Column J shows the price.
I would like to create a pivot table (or whatever...doesn't have to be a pivot table) that pulls out each part number and to the right of it, show the different prices and their corresponding dates.
Here's what my data looks like:
Sheet1
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
1 | 268450 | 7221 | TMMC | 10/6/2017 | 10/6/2017 | 268450 | ABAC7284D14 | E551 | 87910-0R210-C0 | 83.1808 | 83.3021 | 4 | 4 | USD | IB | 83168 |
2 | 268450 | 7221 | TMMC | 10/6/2017 | 10/6/2017 | 268450 | ABAC7284D14 | F260 | 87910-0R210-B0 | 38.9443 | 38.8914 | 4 | 4 | USD | IB | 83168 |
3 | 268450 | 7221 | TMMC | 10/6/2017 | 10/6/2017 | 268450 | ABAC7284D14 | E636 | 87940-0R190-B2 | 37.7509 | 38.2813 | 4 | 4 | USD | IB | 83168 |
4 | 268450 | 7221 | TMMC | 10/6/2017 | 10/6/2017 | 268450 | ABAC7284D14 | G537 | 87940-0R220-A1 | 37.7509 | 38.2813 | 4 | 4 | USD | IB | 83168 |
5 | 268450 | 7221 | TMMC | 10/6/2017 | 10/6/2017 | 268450 | ABAC7284D14 | G657 | 87940-0R190-K0 | 37.7509 | 38.2813 | 4 | 4 | USD | IB | 83168 |
6 | ||||||||||||||||
7 | 268451 | 7221 | TMMC | 10/7/2017 | 10/6/2017 | 268451 | ABAC7284D15 | E480 | 87910-0R210-C0 | 38.9443 | 38.8914 | 8 | 8 | USD | IB | 83168 |
8 | 268451 | 7221 | TMMC | 10/7/2017 | 10/6/2017 | 268451 | ABAC7284D15 | G464 | 87940-0R190-A0 | 43.1304 | 43.6608 | 4 | 4 | USD | IB | 83168 |
9 | 268451 | 7221 | TMMC | 10/7/2017 | 10/6/2017 | 268451 | ABAC7284D15 | E402 | 87940-0R190-B1 | 43.1304 | 43.6608 | 4 | 4 | USD | IB | 83168 |
10 | 268451 | 7221 | TMMC | 10/7/2017 | 10/6/2017 | 268451 | ABAC7284D15 | E134 | 87940-0R190-B2 | 43.1304 | 43.6608 | 8 | 8 | USD | IB | 83168 |
11 | 268451 | 7221 | TMMC | 10/7/2017 | 10/6/2017 | 268451 | ABAC7284D15 | G337 | 87940-0R190-C0 | 43.1304 | 43.6608 | 12 | 12 | USD | IB | 83168 |
12 | 268451 | 7221 | TMMC | 10/7/2017 | 10/6/2017 | 268451 | ABAC7284D15 | G497 | 87940-0R190-D1 | 43.1304 | 43.6608 | 4 | 4 | USD | IB | 83168 |
13 | 268451 | 7221 | TMMC | 10/7/2017 | 10/6/2017 | 268451 | ABAC7284D15 | G883 | 87940-0R190-K0 | 43.1304 | 43.6608 | 4 | 4 | USD | IB | 83168 |
14 | ||||||||||||||||
15 | 268450 | 7221 | TMMC | 10/9/2017 | 10/6/2017 | 268450 | ABAC7284D14 | E551 | 87910-0R210-C0 | 14.2154 | 83.3021 | 4 | 4 | USD | IB | 83168 |
16 | 268450 | 7221 | TMMC | 10/9/2017 | 10/6/2017 | 268450 | ABAC7284D14 | F260 | 87910-0R210-B0 | 65.1232 | 38.8914 | 4 | 4 | USD | IB | 83168 |
17 | 268450 | 7221 | TMMC | 10/9/2017 | 10/6/2017 | 268450 | ABAC7284D14 | E636 | 87940-0R190-B2 | 14.6445 | 38.2813 | 4 | 4 | USD | IB | 83168 |
18 | 268450 | 7221 | TMMC | 10/9/2017 | 10/6/2017 | 268450 | ABAC7284D14 | G537 | 87940-0R220-A1 | 78.1258 | 38.2813 | 4 | 4 | USD | IB | 83168 |
19 | 268450 | 7221 | TMMC | 10/9/2017 | 10/6/2017 | 268450 | ABAC7284D14 | G657 | 87940-0R190-K0 | 46.4878 | 38.2813 | 4 | 4 | USD | IB | 83168 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 49px;"><col style="width: 35px;"><col style="width: 46px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 49px;"><col style="width: 93px;"><col style="width: 37px;"><col style="width: 105px;"><col style="width: 68px;"><col style="width: 56px;"><col style="width: 56px;"><col style="width: 21px;"><col style="width: 32px;"><col style="width: 19px;"><col style="width: 42px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
And here's what I'd like my summary table to look like:
Sheet1
I | J | K | |
22 | 87910-0R210-C0 | 10/6/2017 | 83.1808 |
23 | 87910-0R210-C0 | 10/7/2017 | 38.9443 |
24 | 87910-0R210-C0 | 10/9/2017 | 14.2154 |
25 | 87910-0R210-B0 | 10/6/2017 | 38.9443 |
26 | 87910-0R210-B0 | 10/9/2017 | 65.1232 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 105px;"><col style="width: 68px;"><col style="width: 56px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4