Cannot Paste Data because not the same size

[maxhecht2]

Hello,

I have 46,000 rows across three columns I am trying to move all of the data into one column. There are many blank cells in all three columns. When I select the whole columns to paste I receive the error that I cannot paste it because the data is not the same size. Why is this? And what is the easiest way to get all of the data into one column?

Thanks,
Max

[CK76]

Is there merged cells in range?

You can concatenate columns via formula and copy and paste values.

[maxhecht2]

There should be no merged cells in the range. Additionally how would I concatenate this data? I know the formula just not sure its purpose in this instance. Thanks.

[CK76]

So you want to have all 3 column in single column right?

Assuming data in columns A to C... using "," as delimiter. In D.

=A1&","&B1&","C1

Copy down.

If above isn't what you are looking for, please upload small sample of your data with manually generated output that you want.

[Aardigspook]

Are you trying to select the second column and paste its data below the data in the first column? If so, the error is because you've selected the whole column (1048576 rows) into a range which can't take that (1048576 minus 46000). Try selecting just the data range then pasting that instead.

[Amanda Wilso]

The simplest CONCATENATE formula to combine the values of cells A1, B1 and C1 is as follows:

=CONCATENATE(A1, A2, A3, A4 )

or

“&” operator

=A1 & A2 & A3 & A4

[parkins5322]

Hi maxhecht2,

If I understand your problem you are trying to copy all the the data from column b and move it into column a below the data that is already there, Aardigspook is correct, when you select the column it is all the cells and trying to paste them into a row that already has data tries to extend past what excel can handle, so instead of selecting the whole row lets use keyboard shortcuts to only select the rows that have data. At the first row of column b hold cntrl + shift and press the down arrow (for some reason you may have to press it twice) this should select all the way down to the last row in the column that has data, release all keys, hold press cntrl+x to cut these cells. Now the best way to move this to column a without having to scroll is the same, select first row in column, cntrl + shift + down arrow and it will bring you to the last cell with data, click the first blank cell below that and then cntrl + v to paste the cells you cut previously, now rinse and repeat till all your data is in one very long column. Now if you want to get rid of all those pesky empty cells, this is easy as well, first select the column, now on your ribbon bar (home tab) near the far right edge there is find and select click this and come down to "go to special" when this opens a new popup select blanks from the set of buttons, then click OK and it will change your selection from the entire row to just the blanks in that row, now right click in one of the selected cells and click delete, in the popup click shift cells up and you will have one long continuous list of data all in one column with no blanks.

Hope this Helps
Cheers
Ken