How do i combine duplicate column headings

M

Mike

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
 
M

Max

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
Click to expand...

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.
 
Top