Creating Dynamic Analysis

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,598
Office Version
  1. 365
Platform
  1. Windows
I have a set of data that includes the following fields
  • Role ID
  • Client
  • Project Code
  • Role
The data in the images is sample data and the Client & Project Codes will be free text when entered and will not have any consistent prefix or suffix.

The data is set out as following in the sheet
6hrvc4.png



I need to create the following reporting style
20iwbgp.png



I thought utilising a Pivot Table to get the data in the row order would work, but it places all the data in the same column
29zwghh.png



I am really struggling to get this to work and wondered if anyone has had a similar problem and resolved it.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Hello,

From your output in the Pivot Table ... would it be feasible for you to test Len() of each celll in order to segregate them into three columns ...???
 
Upvote 0
I have spoken with the client about this and they have expressed an interest in utilising VBA code.....much easier!!!
 
Upvote 0
Just change the pivot table design to use tabular layout?
 
Upvote 0
I tried this (do you mean Classic?) but the 1st instances of each element appeared in the same row.

Is there a different layout option available?
 
Upvote 0
Sorry, I meant Outline, not tabular.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

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