Ask Your Question

How to you merge multiple columns but keep separated by rows? [closed]

asked 2014-01-24 07:35:44 +0100

phire404 gravatar image


I have a spreadsheet where I have to merge multiple columns but want to keep them separated by rows. For example I have 20 rows and 10 columns. I would like to merge columns D, E, F without deleting any information but keep everything specarted by rows. How do you do this? Thank you.

Best Regards,


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 03:39:17.488002

1 Answer

Sort by » oldest newest most voted

answered 2014-01-24 08:01:34 +0100

oweng gravatar image

updated 2014-01-25 05:24:07 +0100

I do not believe this is currently possible, but I will update my original answer with an example for clarity. This Excel feature, evidently known as "merge across", has been reported as enhancement request fdo#53850. Given four cells of data in A2:B3:

merging multiple rows

... selecting this range, it is not possible to obtain, via any option, the indicated "Required result". Answering "Yes" or "No" to the question "Should the contents of the hidden cells be moved into the first cell?" results in that shown i.e., both rows are merged.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-01-24 07:35:44 +0100

Seen: 10,434 times

Last updated: Jan 25 '14