Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating Data from Columns into Rows | Excel Discussion (Misc queries) | |||
Consolidating data?? | Excel Worksheet Functions | |||
consolidating two columns | Excel Discussion (Misc queries) | |||
consolidating two columns | Excel Discussion (Misc queries) | |||
Consolidating??? | Excel Discussion (Misc queries) |