Hi everyone,
I'm having a Power Query in excel. And columns(not included as a part of the power query table) next to the Power Query table are either formula driven or hard-coded values.
So suppose the table in the excel is from Cell A1 till D5 and the other columns next to the Power Query table are from E1 till H5. First row is header, so the formula driven or hard-coded cells starts from cell E2 till H5.
Now when I add a whole new row in the excel say between row 4 and 5, it copy paste the formula part wherever possible in the cells between E4 and E5(also for other columns like between rows F4 & F5, G4 & G5, H4 & H5) but no new cell is getting added where there are hard-coded values above or below that particular cell. So if Column E and F are formula based, it automatically adds a new cell but doesn't add a new blank cell/cells where there are rows with manual/hard-coded data.
