Dealing with data in several columns AND rows

R

RJPerri

Hello,
I am working on a huge spreadsheet that has data in several columns and
three rows. I realize grouping the rows will allow me to sort the data
better, but the data is downloaded daily so if I go through and group
it, I will have to do it every day. I have been trying to create a
macro but haven't figured out how!!! Basically what I want is to be
able to automatically select rows 2 and 3 of the data and group them to
row 1... Does anyone have any ideas? Or any other way I can sort the
data better??? :mad: :confused:
 
Y

y_not

"Concatenate" will join the data in two columns into a single column and
would probably be as easy as running the macro?

This only works with text e.g. first name/surname - to leave a space
between them use something like =concatenate(A1," ",A2)
 
R

RJPerri

That is a cool command, but there are more than two rows of data and the
data in the second and third rows are also in several columns...
Basically the spreadsheet pulls data from three databases that should
be identical...

So the three rows of data is the same data but different sources.
 
Top