Hi
I have columns of data that are mostly merged. I would like to extract data of the merged (and unmerged) cells to the left of the merged cells. Please see attached spreadsheet for clarification.
Thank you in advance.
Hoss
Hi
I have columns of data that are mostly merged. I would like to extract data of the merged (and unmerged) cells to the left of the merged cells. Please see attached spreadsheet for clarification.
Thank you in advance.
Hoss
In A1 Cell
=IF(B1<>"",B1,INDEX(A:A,ROW()-1))
Drag it down...
Copy the A1 cell formula and paste it to rest of the cells.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixthsense
Thank you so much for your quick response. It works great.
Hoss
Arulselvan1978,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Please do not quote whole posts
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks