How to Combine Data in Different Columns

  • Thread starter Thread starter hce
  • Start date Start date
H

hce

Hi Everyone

I need help in this issue. I have tried many ways though some wer
successful but they were not efficient.

I have say 5 columns of data and the data could be on the same rows o
all 5 columns or on different rows hence if I need to combine all th
data of these 5 columns, I would have to sort or filter each of the
manually and copy and paste to a different worksheet or column. This i
very tedious and time consuming. I also tried to write a macro to loo
for data in one column then put them into another column but i was no
successful. However, experts like you guys shouldn't have any problem
figuring this out, yeah...? I await your good news with abate
breath...

Cheers
Kelvi
 
I'm afraid you're going to have to abate your breath a while longer.
Please don't turn blue...

You probably have a very good idea of what "combine data" means to you.
Based on your description, however, it is not at all clear to me what
you mean - what data? how do I know which rows to combine? will it be a
different row for each column? Where should the result go? Will each row
have something to combine with? If not, what happens to those that
don't? Etc., etc., etc...

Try giving some examples.
 
Back
Top