Custom Delimiter? Archive Unused Data?

[mm12326]

I need ideas for a problems im trying to solve. I am putting together a dashboards with datafeeds from multiple sources and i am only normailzing only 13 columns from each. I would like to merge the other data from the unused columns into an archieve column, but the problem i run into is that the data is different across the different sources and the column header is needed for context. Is there a way to merge columns by a custom delimiter and use the header? Or does anyone have any other ideas?

[v-piga-msft]

Hi @mm12326 ,

Have you solved your problem?

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[v-piga-msft]

Hi @mm12326 ,

I still have a little confused about your scenario. It seems that you want to merge the colums from different tables to be one column? 

If it is convenient, could you share some data sample which could reproduce your scenario and your desired output so that I could understand your scenario better and help further on it.
Best  Regards,

Cherry