Extracting Text from Pivot Table

Kyle_S

New Member
Joined
Jul 7, 2015
Messages
2
Hello,
I am trying to extract text from multiple cells that exist in a pivot table and return the concatenated text to one single cell in a separate workbook. Below are more details on what I am talking about.

In workbook one, there are data in this format in a pivot table:
Column A) Line Title
Column B) RU Title
Column C) Comment

I would like to have the formula search for a specific set of Line Title and RU Title and return the associated comment. For example, the line title might be "Advertising" the RU Title "Asia" and the Comment "+1.4 million; television". It is possible that there will be multiple rows that flow Advertising-->Asia--> Comment and I would like this formula to return ALL of those comments together in one single cell.

Thanks in advance for your help.

Kyle S.

p.s. I basically want to do a SUMIFS() but for text...
 
Last edited:

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,118,810
Messages
5,574,436
Members
412,593
Latest member
VBA Novice123
Top