Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Pulling Cell values into Pivot table

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Pulling Cell values into Pivot table

    I have a set of data in 3 columns:

    A. Date (Number in Date format)
    B. Project Name (Text)
    C. Status (Text)

    If there a way to set up a pivot table to return Project Names in the Rows / Month in Column / Status Value in the Value area.

    eg. like this

    Date, Jan, Feb, Mar, Apr
    Project name 1, Red, Green, Amber, Red
    Project name 2, Green, Green, Amber, Red
    Project name 3, Red, Amber, Green, Red

  • #2
    Re: Pulling Cell values into Pivot table

    Hello,

    It seems you are looking for a Text-based Pivot table ...

    Robert Mundigl has created a very interesting technique ...

    see link http://www.clearlyandsimply.com/clea...using-vba.html

    Hope this will help you ...
    To say "Thank You" for the help received ...Just click on the "Like" icon ...underneath ... ... in the bottom right corner ...

    Comment

    Trending

    Collapse

    There are no results that meet this criteria.

    Working...
    X