tricky pivot table scenario

Hi expert's excel 2007

is it possible to take certain values from col b and certain values from col c and create a pivot table..where the user can pick and choose which vlues they want to show.

Table A
Col A.                Col B.                Col C
Abc.                     24.                    7
Dcf.                      12.                   10
Tgfd.                     9.                     57
Ytu.                       6.                     53
Ott.                       44.                  19
Yuu.                      52.                  11

Pivot Table
Labels.          Result
Abc.               24.     Take from col b
Dcf.               10.      Take from col c
Tgfd.               9
Ytu.                6
Ott.                19
Yuu.               52
route217JuniorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
Not without a separate column of data that the pivot table can use. (I don't really see the connection to a pivot table in your example, but assume it's simplified)
0
route217JuniorAuthor Commented:
So separate column...it the best route...I am using pivot table because of the volume of data...
0
Rory ArchibaldCommented:
I think so, yes.
0
5teveoCommented:
change the original data relationship to       something like

Name      Col      Value
Abc      ColB      24
Dcf      ColB      12
Tgfd      ColB      9
Ytu      ColB      6
Ott      ColB      44
Yuu      ColB      52
Abc      ColC      7
Dcf      ColC      10
Tgfd      ColC      57
Ytu      ColC      53
Ott      ColC      19
Yuu      ColC      11

Offers building Pivot table that will allow you to click on columns you choose...
ExcelChart.png
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
What is the theory/logic behind which column to choose?

With the option above, you can choose "Col B for All values" or "Col C for All values" or "Both for All values" not a combination of Col B for some and Col C for others.

If you can formulate the logic for which value to choose and put that into a column, you can then reference that column instead.

Thanks
Rob H
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.