Info in different columns in same row

[dlorenzo]

Hello,

I'm attaching a spreadsheet in which I need to see the values for "Company" and "Amount Paid" in the same row so that I can filter the data and manipulate it further. The actual report I have is almost 5,000 lines and each "Amount Paid" is a different number of rows down from the "Company". On the attached should be a better explanation of what is needed.

If there is a better way to show the data in the same row than what I am currently attempting, please let me know.

Thank you in advance.

Company Pay Info.xlsx

[AlKey]

Hello dlorenzo,

Unfortunately, the spreadsheet you have provided does not include any data and therefore makes it impossible to offer you a solution.
Try to upload a spreadsheet (10-20 rows) with accurate representation of your data and clear explanation of what needs to be calculated.

[dlorenzo]

Should be attached now. Sorry about that.

[AlKey]

You sent the same file without data.

[dlorenzo]

I don't understand what is going wrong with this. I'm attaching the file as I always do. I see the file attached here, and it has data when I open it.

I'm going to save the file under a different name and try one more time.

[Max, Singapore]

First, create this helper col which associates the company all the way through
In E4: =B4
In E5: =IF(ISNUMBER(SEARCH("Company",B5)),B5,E4)
Copy E5 down to E31

Then ...
Put in K2, normal ENTER to confirm: =INDEX($D$4:$D$31,MATCH(1,INDEX(($E$4:$E$31=I4)*($D$4:$D$31="Amount Paid:"),),0)+1)
Copy K2, paste into K15

Put in I11: =INDEX($E$4:$E$31,MATCH(J11,$D$4:$D$31,0))
Copy I11, paste into I30

Above should return the results that you seek
-----------------------------------------------
Success? Celebrate it, click the little star at the bottom left of my responses

[Max, Singapore]

Not sure what's happening, but I was able to access your 1st post's attachment ... and have offered a solution

[dlorenzo]

Works great, thank you. Sorry if I had issues with the uploads.

[AlKey]

Weird. All I get is a Sheet1 with no data

[Max, Singapore]

Not sure what you meant by "no data", but Op's data scenario as posted in his Sheet1 is actually rather sparse

[Max, Singapore]

Glad it worked out ok for you. Do also take a moment to hit that little star at the bottom left of my responses, won't you?