Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
56
Views
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".
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
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
