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 !!! |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com