Which Formula i should apply and how

[arslan hussain]

Hello Everyone,

Please find the attached sheet. I am experiencing an issue with my excel. I want to remove rows starting with the billing no but under these rows there are other data like date and total amount and i want to keep them in the file. Additionally, i want date and total amount in the columns instead of rows against the claim no rows. Can someone please guide me, how i can fix this?

 

[RaulARodriguez]

Is this something you wil do often? If so, you will need VBA code. If it is seldomly done, you can get away with a 5 steps process:

1. Place a formula similar to this

   =IF(MID($A2,1,7)="Billing",CONCATENATE(A2," ",B2," ",C2," ",TEXT(D2,"MM/DD/YY")," ",E2," ",F2)," ")

2. Drag it down until the last row of your data set
3. Copy/paste value this column on itself
4. Place a filter on this column and delete blank rows

Please note that since your picture does not display column or row indexes I assumed you are starting in cell A1