Forum

Concatenate values ...
 
Notifications
Clear all

Concatenate values from two rows into a cell in new column

3 Posts
2 Users
0 Reactions
180 Views
(@ismail-rajiwate)
Posts: 2
New Member
Topic starter
 

Hi,

Request your expert guideline and help to achieve the below case.

I have a Bank Statement which looks as shown in attached Screenshot1

The bank statement shows the description in two rows. To perform the bank reconciliation, I have to merge the description into new column and in one cell like shown in attached screenshot2.

How can I achieve this in power query? Please guide me I am new for PQ and Power BI.

Thanking you in anticipation

IsmailScreenshot1.pngScreenshot2.png

 
Posted : 25/02/2022 2:58 am
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

Perhaps the attached file will help you on your way.

 
Posted : 25/02/2022 4:15 am
(@ismail-rajiwate)
Posts: 2
New Member
Topic starter
 

Shukran, very quick, helpful and simple to understand reply.

 
Posted : 25/02/2022 5:37 am
Share: