Creating complex Pivotable

andyka

Board Regular
Joined
Sep 20, 2021
Messages
52
Office Version
  1. 2019
Platform
  1. Windows
Hi I have data in in Three columns. I am looking to show data in shown format either using formulas or pivotable.
Any help please.

Trials Projects - Stage Gate 1 to 5.xlsx
BCDEFGHIJKLMNOP
4Show in a format shown below
5
6Activity IDStartFinishSTAGE GATE 1STAGE GATE 2STAGE GATE 3STAGE GATE 4STAGE GATE 5
7P116-Mar-2326-Feb-27P116-Mar-2316-Mar-2303-Aug-2303-Aug-2320-Mar-2520-Mar-2529-Sep-2629-Sep-2626-Feb-2726-Feb-27
8STAGE GATE 116-Mar-2316-Mar-23P2
9STAGE GATE 203-Aug-2303-Aug-23P6
10STAGE GATE 320-Mar-2520-Mar-25P7
11STAGE GATE 429-Sep-2629-Sep-26P8
12STAGE GATE 526-Feb-2726-Feb-27P5
13P221-Jul-2322-Oct-26P9
14STAGE GATE 221-Jul-2321-Jul-23P10
15STAGE GATE 313-Dec-2413-Dec-24
16STAGE GATE 401-Jun-2601-Jun-26
17STAGE GATE 522-Oct-2622-Oct-26
18P613-Sep-2311-Nov-27
19STAGE GATE 113-Sep-2313-Sep-23
20STAGE GATE 227-Jun-2427-Jun-24
21STAGE GATE 326-Nov-2526-Nov-25
22STAGE GATE 421-Jun-2721-Jun-27
23STAGE GATE 511-Nov-2711-Nov-27
24P717-Feb-2324-Aug-27
25STAGE GATE 117-Feb-2317-Feb-23
26STAGE GATE 227-Nov-2327-Nov-23
27STAGE GATE 307-May-2507-May-25
28STAGE GATE 431-Mar-2731-Mar-27
29STAGE GATE 524-Aug-2724-Aug-27
30P823-Feb-2414-Feb-28
31STAGE GATE 123-Feb-2423-Feb-24
32STAGE GATE 225-Nov-2425-Nov-24
33STAGE GATE 320-May-2620-May-26
34STAGE GATE 415-Sep-2715-Sep-27
35STAGE GATE 514-Feb-2814-Feb-28
36P518-Oct-2325-Nov-27
37STAGE GATE 118-Oct-2318-Oct-23
38STAGE GATE 201-Aug-2401-Aug-24
39STAGE GATE 319-Mar-2619-Mar-26
40STAGE GATE 405-Jul-2705-Jul-27
41STAGE GATE 525-Nov-2725-Nov-27
42P915-Sep-2327-Mar-25
43STAGE GATE 315-Sep-2315-Sep-23
44STAGE GATE 428-Oct-2428-Oct-24
45STAGE GATE 527-Mar-2527-Mar-25
46P1024-Oct-2320-Jul-26
47STAGE GATE 224-Oct-2324-Oct-23
48STAGE GATE 330-Oct-2430-Oct-24
49STAGE GATE 420-Feb-2620-Feb-26
50STAGE GATE 520-Jul-2620-Jul-26
RawData
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Does anyone has any ideas how to accomplish this please
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

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
Back
Top