Working with Merged cells / sorting

[Irishtone]

Hi all,

I am hoping there's a quick fix for this recurring problem I have....

I download to excel from a sales package where customers are grouped into categories.
These categories appear in excel as merged cells (Col. A) the account numbers in Col.B.
I cannot sort the sheet due to the merged cells of course, but if I remove the merging in alignment then I only see the category against the top account.
Apart from manually going through the sheet and pasting the category back in against all of the relevant accounts.
Is there a simple way to fill this value against the relevant accounts ?

So that I would see, on each line, Category (Col.A) Account number (Col.a) etc ?

Thanks in advance everyone

T

 

[Dannyh1]

Hi,

(assuming you are starting from row 2)

Try unmerging your cells

Highlight A2 to the end

Edit - Go to - Special - select Blanks - OK - type "= A2" - Ctrl Enter

This should fill in the blanks (check the very last row has been copied to bottom)

Copy Paste Values only column A

 

[Irishtone]

Hey Danny,

I tried that, and it was picking up the first one.
I've substituted the "A2" for the Up arrow and it's worked perfectly.

I am now off for a leisurely coffee as this has saved me literally Hours.!!

Thank you SOOO much!!