Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concat and summarize 6 columns to 2 columns
I have a spreadsheet with 6 columns and thousands of rows. The first
column is the id Example of the data (6 columns)- 04731 CRM 2 EX 97 01 04731 CRM 5 LX2WD 97 01 04731 CRM 5 LX4WA 97 01 04731 RVB 5 LX4WD 91 95 04731 RVB 5 SE 91 95 25475 MMX 2 FR 95 96 25475 MMX 5 GR 96 97 Result desired (2 columns)- 04731 CRM 2 EX, 5 LX2WD, LX4WA 97 01; RVB 5 LX4WD SE 91 95 25475 MMX 2 FR 95 96, 5 GR 96 97 Idea is to summarize the data of 5 columns in 1 column and eliminate the duplicates Any help is greatly appreciated. Thanks !!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Setting up and Configuration of Excel | |||
Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |