Repeat the missing column data!!

**johnbest** · 10-18-2012, 02:29 AM

Hi there,

I am having a strange situation... our client send me a file with following format...
MS Excel version is 2003

SNo Name OrderId
1 Jack Ord1
2 Ord22
3 Ord34
4 Jill Ord47
5 Ord51
6 Ord645
7 Jane Ord787
8 Ord809
........................
........................
........................

The output I required is as -

SNo Name OrderId
1 Jack Ord1
2 Jack Ord22
3 Jack Ord34
4 Jill Ord47
5 Jill Ord51
6 Jill Ord645
7 Jane Ord787
8 Jane Ord809
........................
........................
........................

Have a nice day
Regards
John

**dilipandey** · 10-18-2012, 02:47 AM

Hi John,

Select any cell in the data...
press ctrl+shift + *
F5
Alt + s (select "Special")
k
Enter
type =
press Up Arrow
Press Ctrl + Enter

So basically we are selecting the blank cells and taking down all the above values by pressing ctrl + Enter..

In case of any issues, upload a sample excel workbook... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**johnbest** · 10-18-2012, 03:33 AM

Dear Dilip Pandey Ji

Thanks a lot and also clicked on the *

Have a nice day
Regards...
John

**dilipandey** · 10-18-2012, 04:02 AM

You are welcome John...

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Cutter** · 10-18-2012, 09:34 AM

@ johnbest

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.