Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columns

Summary:

Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address from Line 1 to country in 1 column.

address line 1, Line 2, city, postal, country in one single column as 'Payee address'

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):