Help to merge multiple columns into one column (after a cross tab)

[alicooper]

Hi

I used Cross Tab to move vertical data into horizontal data (one PPC per row) but now I would like to merge the text in the multiple columns into a single new column. Workflow and original data attached.

Thank you!

Ali

[DataBlender · Accepted solution]

Hi @alicooper 

Please could you clarify what you mean by one new column? As the data was already in one column.

If you want just one row per PPC with all of the options in one column, you can use the Summarize tool on your raw data to group by PPC then Concat the name field (the option is found within 'String').

Output would be like this:

PPC	Concat_Name
AL3	NHS Bedfordshire CCG,NHS Herts Valleys CCG

Original data:

PPC	Name
AL3	NHS Bedfordshire CCG
AL3	NHS Herts Valleys CCG

[alicooper]

Perfect, thank you.

I then also did a Text to Column after so I now have a PPC column, a concatenated column, and then the individual CCG names in seperate columns.

PPC	Concat_Name	Concat_Name1	Concat_Name2
AL3	NHS Bedfordshire CCG,NHS Herts Valleys CCG	NHS Bedfordshire CCG	NHS Herts Valleys CCG

Thanks

Ali