Forum

Excel Power Query -...
 
Notifications
Clear all

Excel Power Query - Merge two cells

2 Posts
2 Users
0 Reactions
121 Views
(@dms)
Posts: 1
New Member
Topic starter
 

Hi,

I am trying to find a way to merge two cells in Power Query before deleting row 1 so that the data in row 2 can be made the column headers.

Example, see attached image. Column 12 row 1 = "16/08/2021" and column 12 row 2 = "Total". Looking to achieve Column 12 row 2 = "Total 16/08/2021".

Power-Query.png

I cannot do in Excel first as the master excel report changes every week so looking to automate with power query before appending three worksheets in Power Query

Any help greatly appreciated.

Thanks

David

 
Posted : 25/08/2021 7:18 am
(@lupirla)
Posts: 3
New Member
 

Hi David

My sugestion is

1.- Transpose de data

2.- fill down the column1

3.- select column1 and column2 and merge them

4.- tranpose the data again

5.- change the column name if needed

Please, tell me if this helped you

 
Posted : 26/08/2021 10:47 am
Share: