ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i combine duplicate column headings (https://www.excelbanter.com/excel-worksheet-functions/68673-how-do-i-combine-duplicate-column-headings.html)

Mike

How do i combine duplicate column headings
 
If CoLumn A, E, I, M, P, U all have Name (with Different names) how do I
combine that so it all fill sout in rows under column A

Max

How do i combine duplicate column headings
 
"Mike" wrote
If CoLumn A, E, I, M, P, U all have Name
(with Different names) how do I
combine that so it all fill sout in rows under column A


Perhaps appropriate in this instance just to do a sequential manual select
of the range of names from all other cols, then cut and paste into col A,
pasting each range below the other continuously. Then do a Data Sort on
col A as desired. The whole op should take only a few minutes to complete.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---




All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com