Very large amount of vertical rows and horizontal columns. Need to merge it into 1 column

[ExcelGebruikerNL]

Hello,

As the title says i have a large amount of vertical and horizontal data. Horizontal the row stretches from cel $A to cell $ADF and vertical the row stretches to number 6000

My goal is to merge this data into ONE column...

Is this possible? I understand that Excel may be can't handle it at once, but if you have suggestions it would be nice if i dont have to repeat the same action 100s of times.

Thanks : )

P.S. See the screenshot

Exceluser Frederick from the Netherlands

[Pepe Le Mokko]

Duplicate post by me

[Pepe Le Mokko]

Hi
try this technique http://chandoo.org/wp/2014/01/13/com...ues-quick-tip/

Be aware you are limited to 32767 characters per cell

PS why do you need to do this? Rather strange

[ExcelGebruikerNL]

Hi
try this technique http://chandoo.org/wp/2014/01/13/com...ues-quick-tip/

Be aware you are limited to 32767 characters per cell

PS why do you need to do this? Rather strange

Hello Pepe,

Thanks for your suggestion.

I want to do this because i have a large portion of my own website and i want to filter some details out of it.
That's why i first have to organise the rows to select and filter on the base of alphabet.

I will try later this day to let know if i managed to solve this problem with your suggestion.

[Pepe Le Mokko]

OK and please don't quote entire posts, they are just clutter. Thanks