Pivoting text data

misiek5510

New Member
Joined
May 25, 2021
Messages
24
Office Version
  1. 2016
Platform
  1. Windows
  2. Mobile
Hi,

I'm looking to pivot a table that is not based on digits but rather on text. Its basically for 4 improvements for 4 different towns, and its current status. Please see example as below.
1.jpg



Now I want to add some cost and it looks as follows :

2.jpg


Then some comments:
3.jpg



Then start and finish date of the improvement.
4.jpg



Now is the tricky part of creating the pivot as it never looks like I want it to look, but ideally it would look like below. Now, it is counting how ON HOLD, N/A, Live and proposal statuses there are per London etc.
5.jpg



Now is the most important part. When I double click on the D3 (with 2 in the cell) I want it to open a summary as per below basically looking up the IMP,COST,COMMENT and Date tabs.

6.jpg


This might be dead simple, but it doesn't work for me. I tried to explain it best I could with keeping it simple, but if anything is unclear please let me know.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

misiek5510

New Member
Joined
May 25, 2021
Messages
24
Office Version
  1. 2016
Platform
  1. Windows
  2. Mobile
I can attach the excel file it this helps. Im on work pc and cannot install mini sheet plug in.
 

Forum statistics

Threads
1,144,684
Messages
5,725,760
Members
422,639
Latest member
i have a question

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top