Need Help with Power Query

[Samhunt]

Hi everyone, I am new to this and I am looking for some help. 

So this is my table. 

STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment
Booking reference	Check-out date	Extras amount (€)	Commercial margin (€)
19589205	07/10/2023	60	0
20161555	12/10/2023	60	0
18420055	22/10/2023	55	0
19436218	28/10/2023	60	0
20321052	05/11/2023	60	0
Subtotal		295	0
STAY Short Lets Ltd, 100 AN - Napa Living 20
Booking reference	Check-out date	Extras amount (€)	Commercial margin (€)
20069136	10/10/2023	28	0
20163033	19/10/2023	28	0
20252619	24/10/2023	28	0
20282267	01/11/2023	28	0
Subtotal		112	0
STAY Short Lets Ltd, 100 AN - Napa Living 16
Booking reference	Check-out date	Extras amount (€)	Commercial margin (€)
20089078	06/10/2023	28	0
20170084	19/10/2023	28	0
20259964	25/10/2023	28	0
20312351	31/10/2023	28	0
Subtotal		112	0

What I want to do is to add a new column that will use the data in the first column. 

Whenever it detects an empty cell, It will return the value below the empty cell, whenever there is some value in the cell it will return the value above the cell in the new column.

 Assume that I am adding a formula in excel In column A in Cell A2 and I use the information on column B my formula will be the following:= IF(B1="", B2, A1)   

This formula results in the following

	Sales profit margin per accommodation and booking
0
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	Booking reference	Check-out date	Extras amount (€)	Commercial margin (€)
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	19589205	07/10/2023	60	0
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	20161555	12/10/2023	60	0
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	18420055	22/10/2023	55	0
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	19436218	28/10/2023	60	0
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	20321052	05/11/2023	60	0
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment	Subtotal		295	0
STAY Short Lets Ltd, 20 ATR -Trinity (1) Apartment
STAY Short Lets Ltd, 100 AN - Napa Living 20	STAY Short Lets Ltd, 100 AN - Napa Living 20
STAY Short Lets Ltd, 100 AN - Napa Living 20	Booking reference	Check-out date	Extras amount (€)	Commercial margin (€)
STAY Short Lets Ltd, 100 AN - Napa Living 20	20069136	10/10/2023	28	0
STAY Short Lets Ltd, 100 AN - Napa Living 20	20163033	19/10/2023	28	0
STAY Short Lets Ltd, 100 AN - Napa Living 20	20252619	24/10/2023	28	0
STAY Short Lets Ltd, 100 AN - Napa Living 20	20282267	01/11/2023	28	0
STAY Short Lets Ltd, 100 AN - Napa Living 20	Subtotal		112	0
STAY Short Lets Ltd, 100 AN - Napa Living 20

So I want to add the property on each row that there is a numerical value in the Booking reference, the empty space will be used to mark that there is a change in property. 

Regards

[lbendlin · Accepted solution]

That's not something you want to do in Power BI.  Bring your table into a usable format (moving the location into its own column)  and then all the other issues will go away.