00:00 Combine 2 rows into 1 row in Excel using Power Query
00:10 Convert the list with gaps into a Table in Excel
00:20 Import the data into Power Query
00:30 Overwrite Power Query making 1st row headers, convert them back to the 1st row
00:55 Combine the data from the 2 rows so that the information required is in one row
01:30 Remove the row that is no longer required
01:50 Rows now merged into 1 containing the data we need
02:00 Load the combined rows back into Excel
Combining rows that correspond with each other into 1 row so that you can work further with the data. Often required when you have exported data from a system and it uses 2 rows per record with some gaps appearing. This method gets all the information required onto a single row and then you can remove/ delete the other row.
Combine 2 rows into 1 record in Power Query
AuditExcel Advanced Excel and Financial Model Training and Consulting
2:21
2022-09-17 15:59
7 951
20
0
Теги
Combine 2 rows into 1 record in Power Querypower query combine rows with same idpower bi combine multiple rows into one columnpower query merge rows based on conditionpower query combine duplicate rowscombine 2 rows in power querycombine rows into one cell power querypower query combine two rows into onepower bi combine multiple rows into onecombine 2 rows inot 1 record in power querycombine 2 rows into 1 recrod in power query