How to get data alligned ,when unmerged is done

[swati vyas]

I have a report which is only available in PDF. Our IT dept converted this into excel. But the report has lot of merged items so i have to unmerge to see true info. when i do unmerge , the data i need comes as under(extract only)


Vendor Name
Invoiced Total
RBC Insurance
468.72

So the Excel column of vendor has the info i need say RBC and the Column of Invoiced total is blank and its related item is under the column of Vendor name in second row below RBC insurance

ALso the Invoiced total is not on same row as Vedor name so I have to manually go thru each line for all such columns ( i have shown only two columns here) and do cut paste to get info under relevent heads to look as under:

Vendor name Invoiced total
RBC Insurance 468.72

Is there a better and faster way around this manual excersice ? I am just a intermediate level excel user.

Thanks

 

[hiker95]

swati vyas,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[tweedle]

So is this what your information looks like?

Excel Workbook
	A	B
1	Vendor Name	Invoiced Total
2	RBC Insurance
3	468.72
4	RBC Insurance
5	468.72
6	RBC Insurance
Sheet

 

[swati vyas]

http://www.box.net/files#/files/0/f/92310311/1/f_785566727
Dear Hiker95

I have given link to the BOX NEt folder i created. Let me know if it works and you can see my files

I have excel 2010 but this file was converted and could be saved only as 2003 version iguess

 

[hiker95]

swati vyas,

Thanks for the link to Box.Net.

But, it is asking me to sign in.

Please go to the site and mark your post/workbook for sharing.

 

[swati vyas]

HI

I have clicked shared so it should be sharable now. sorry and htanks

The file has two tabs. One for original file i get and 2nd tab shows how end result should be.
I have asked addtional help on page 2 if yu can. thanks

 

[hiker95]

swati vyas,

The link to Box.Net, is still asking me to sign in.

 

[swati vyas]

Dear Hiker95

I have gone to the log in and gone to advanced and cliked view to all. If it still doesnot work, please let me know what more i need to do? thanks and sorry

swati

 

[hiker95]

swati vyas,

The link to Box.Net, is still asking me to sign in.


You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[swati vyas]

Dear hiker95

my login in boxnet is
jaychiragvyas@yahoo.ca
and password is
babaji1

will this help? I tried the other methods but i am not a very computer smart i couldnot get to do it. Hence i prefer you go in box net as me and view it. sorry for wasting your time and thanks