Forum Discussion

HemanthV's avatar
HemanthV
Helper II
4 years ago
Solved

Concatenate cell value to Column Name

Hi Guys,   I have data like below   CountryCityPeriod A aa P8 A bb P8 A cc P8 A dd P8 B ee P8 B ff P8 B gg P8 B hh P8 B ii P8 C jj P8 C kk ...
  • wdx223_Daniel's avatar
    4 years ago

    NewStep= Table.RenameColumns(PreviousStepName,{"City","City ("&PreviousStepName[Period]{0}&")"})