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,

I have looked at your workbook, but I do not understand your requirements.


Click on the Post Reply button, then just enter the word BUMP, and click on the Submit Reply button, and someone else will assist you.

 

[swati vyas]

Bump