Create a list of unique entries from a 31x31 spreadsheet

[Manzar.A]

Hello, I have a somewhat complicated issue. I created a spreadsheet with lots of daily inputs, like sales and costs of delivery per type, and comes from 10 different suppliers. All that information is routed into a monthly format in a different sheet in the same spreadsheet {Monthly}. I am looking to create a list of expenses in the format of [Date] [Expense Amount] [Company Name] [Income Amount (H2:H32)] [Balance].

There are 31 ways I spend my money in the company, most of which are used only monthly or annually. They all are gray colored in the sheet (AW:CB) multiplied by 31 days. I know how to do the balance and income amount. I don't know how to pull the Expense Amount and Company Name, conditional on them actually being filled in. I'd prefer to have them fill in 3 lines for every day for viewing consistency, then fill in the payments. There is a special spreadsheet called {Payments} which I want to populate with the data.

So, check every row from (AW:CB) 2 to 32, for any filled-in cells, grab the data into Column B, pull the Company name for Column C, check for cells being clear, then go for the next item.

If I wasn't clear on this, please let me know.
Edit: Updated the spreadsheet to have sample values.

Here, I have entered the purchase of a few items and their payment date comes out 7 days later.

[JeteMc]

Hello Manzar.A and Welcome to Excel Forum.
Try the following.
For B2 and down:

Please Login or Register  to view this content.

For C2 and down:

Please Login or Register  to view this content.

Let us know if you have any questions.

[Manzar.A]

Holy! That worked beautifully! Thank you very much. The limitation that this brings up now is that in case I have more than 3 spendings in a day, the extra spendings won't show up anymore. I'll do those manually.

[JeteMc]

My suggestion would be to add a helper column (A) which could be hidden for aesthetic purposes.
Populate the helper column using: =IF(ISNUMBER(B2),1,SUM(A1,1))
Modify the formula in the Vendor column to read:

Please Login or Register  to view this content.

Note that if a row is added to the range on the Payments sheet then you'll need to drag the formulas down from the row above.
I also made some changes to the formulas in the Income and Balance columns.
Let us know if you have any questions.