Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2022, 07:28 PM
Colonel Biggs Colonel Biggs is offline Trying to reduce cells with two rows to one row Mac OS X Trying to reduce cells with two rows to one row Office 2016 for Mac
Advanced Beginner
Trying to reduce cells with two rows to one row
 
Join Date: Jul 2010
Posts: 52
Colonel Biggs is on a distinguished road
Default Trying to reduce cells with two rows to one row

I inherited an Excel spreadsheet (Office 365 - Mac) where some of the cells are divided into two rows. How do I get them back to one cell/one row?
Reply With Quote
  #2  
Old 07-30-2022, 11:27 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Trying to reduce cells with two rows to one row Windows 7 64bit Trying to reduce cells with two rows to one row Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet ( no pics please)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 08-01-2022, 03:55 AM
ArviLaanemets ArviLaanemets is offline Trying to reduce cells with two rows to one row Windows 8 Trying to reduce cells with two rows to one row Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by Colonel Biggs View Post
I inherited an Excel spreadsheet (Office 365 - Mac) where some of the cells are divided into two rows. How do I get them back to one cell/one row?
What do you mean with "two rows"?
Do you have the cells in one column formatted to wrap the text, and the text is entered as several lines into cells in this column, using Alt + Enter?
Or are in other columns of your table rows merged pairwise, exept a single column where rows are left unmerged?
Reply With Quote
  #4  
Old 08-01-2022, 08:26 AM
kilroyscarnival kilroyscarnival is offline Trying to reduce cells with two rows to one row Windows 10 Trying to reduce cells with two rows to one row Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

I have the same question as Arvi above.

I've made an example where some entries are typed in two different cells/rows, and some are just broken with the ALT+Enter to show up on a second line in the same cell.

In the first example where they are in two different cells, you can use a Concatenate formula to combine the contents of the two cells, and in this case, adding the comma and space in between them.

In the "Peppermint Patty" example, I used Find/Replace, and in the Find cell I typed a CONTROL+J, and replaced with the comma and the space. It eliminates the manual line break in the Excel cell.

Another method entirely if you have a lot of those line breaks within the cell would be to transform your document in PowerQuery if you have it. There's a command in there which would make it easy to remove those line breaks. I have PowerQuery within Excel 365 for Windows but I don't know anything about the Mac side.
Reply With Quote
  #5  
Old 08-01-2022, 08:28 AM
kilroyscarnival kilroyscarnival is offline Trying to reduce cells with two rows to one row Windows 10 Trying to reduce cells with two rows to one row Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Forgot to add the image of what I did in the example.
Attached Images
File Type: jpg Screenshot 2022-08-01 104723.jpg (93.5 KB, 15 views)
Reply With Quote
  #6  
Old 08-01-2022, 06:07 PM
Colonel Biggs Colonel Biggs is offline Trying to reduce cells with two rows to one row Mac OS X Trying to reduce cells with two rows to one row Office 2016 for Mac
Advanced Beginner
Trying to reduce cells with two rows to one row
 
Join Date: Jul 2010
Posts: 52
Colonel Biggs is on a distinguished road
Default

Please excuse the delay; I injured my back shortly after making the post, which put me out for a few days.

My spreadsheet that I received had column titles in which two rows were shown to take up one cell. Or, the titles took up the entire cell, despite the cell having a height that amounted to two rows.

I finally came upon Format Cells/Alignment/Text Control: uncheck Merge Cells. This did the trick. I was back to being able to use each row to a cell.

Sorry for the confusion. But, I appreciate the responses.
Reply With Quote
  #7  
Old 08-02-2022, 05:30 AM
kilroyscarnival kilroyscarnival is offline Trying to reduce cells with two rows to one row Windows 10 Trying to reduce cells with two rows to one row Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by Colonel Biggs View Post
Please excuse the delay; I injured my back shortly after making the post, which put me out for a few days.

My spreadsheet that I received had column titles in which two rows were shown to take up one cell. Or, the titles took up the entire cell, despite the cell having a height that amounted to two rows.

I finally came upon Format Cells/Alignment/Text Control: uncheck Merge Cells. This did the trick. I was back to being able to use each row to a cell.

Sorry for the confusion. But, I appreciate the responses.
Ah, your problem was even more straightforward than I guessed. Funny thing is, shortly afterward, I found myself tackling a similar spreadsheet which has items on two rows instead of one. Glad you worked it out.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to reduce cells with two rows to one row How to hide rows that have no data but has formula in cells? LearnerExcel Excel Programming 8 02-13-2018 06:31 AM
Split data in cells and duplicate rows ballpoint Excel Programming 6 02-07-2018 05:52 PM
Trying to reduce cells with two rows to one row Deleting rows based on the text in certain cells VBA ThisGuyJohn Excel Programming 5 02-03-2017 03:16 PM
VBA merging cells and counting Merged rows Snaybot Excel Programming 2 11-09-2015 03:56 AM
How to make rows or cells shift down automatically rfrontz Excel 1 04-16-2013 03:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft