Creating a Table from Multiple Columns with Multiple results

**ChemistB** · 04-13-2010, 02:37 PM

Can I compile multiple (nonconsecutive) columns into 1 field in a pivot table? I have attached a simple example of what I have and want. Column A has a list of compounds, Columns B,D,F and H list the tests needed for that compound. (In actuallity there are maybe 100 different tests although never more than 6 for a single compound.)
I want to pivot table (or through VBA or Formula) the Test followed by the compounds that are tested with that test. Thanks in advance.

Had this moved from General because I believe will need a VBA solution. Thanks!

**Mikeopolo** · 04-13-2010, 03:38 PM

Pivot tables deal in numeric data (in the data section that is - ie sums, averages, etc), what you will need is someone more capable with VBA than I am to prepare a script to re-summarise your table.

**ChemistB** · 04-15-2010, 01:38 PM

Any ideas on how to do this?

**WHER** · 04-15-2010, 02:38 PM

One possible way to do it.

**ChemistB** · 04-15-2010, 03:27 PM

Perfect WHER, just what I needed. Thanks

Creating a Table from Multiple Columns with Multiple results

LinkBack

Thread Tools

Rate This Thread

Display

Creating a Table from Multiple Columns with Multiple results

Re: Pivot Table on Multiple Columns

Re: Creating a Table from Multiple Columns with Multiple results

Re: Creating a Table from Multiple Columns with Multiple results

Re: Creating a Table from Multiple Columns with Multiple results

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions