Consolidating Columns
 

Hello!
For columns with the same value, how do I consolidate the values under
those identical columns into one instance of the column name?


I have this:
Facility Plant 1 Plant 1 Plant 1 Plant 2 Plant 2 Plant 2
App app 1 app2 app 4 app 3 app 5 app 7

I would like this:
Facility Plant 1 Plant 2
Apps app 1 app 3
app 2 app 5
app 4 app 7

And this would be even better:
Facility Plant 1 Plant 2
Apps
App 1 x
App 2 x
App 3 x
App 4 x
App 5 x
App 6
App 7 x


Thanks!
--
Aidan

Consolidating Columns
 

Assuming your source data is in Sheet1, in rows 1 and 2 across
and in Sheet2, you have the table below with the column & row headers
prepared:
Facility Plant 1 Plant 2
Apps
App 1
App 2
App 3
etc

Place in B3 (ie the top left cell to populate):
=IF(SUMPRODUCT((TRIM(Sheet1!$1:$1)=TRIM(B$1))*(TRI M(Sheet1!$2:$2)=TRIM($A3)))0,"x","")
Copy across to C3, fill down to populate

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Aidan" wrote:
For columns with the same value, how do I consolidate the values under
those identical columns into one instance of the column name?


I have this:
Facility Plant 1 Plant 1 Plant 1 Plant 2 Plant 2 Plant 2
App app 1 app2 app 4 app 3 app 5 app 7

I would like this:
Facility Plant 1 Plant 2
Apps app 1 app 3
app 2 app 5
app 4 app 7

And this would be even better:
Facility Plant 1 Plant 2
Apps
App 1 x
App 2 x
App 3 x
App 4 x
App 5 x
App 6
App 7 x


Thanks!
--
Aidan

Consolidating Columns
 

So, did it work out ok for you? I tested it ok here prior to posting. Post
some feedback, engage the responder(s).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Consolidating Columns
 

Max,
Worked perfectly. Thanks!!!!!!!!


--
Aidan


"Max" wrote:

So, did it work out ok for you? I tested it ok here prior to posting. Post
some feedback, engage the responder(s).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Consolidating Columns
 

Welcome, great to hear.
Thanks for feedback
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Aidan" wrote in message
...
Max,
Worked perfectly. Thanks!!!!!!!!