Append Column Names to Data Rows

[vinayR96]

Hi, 

I've a Dataset where I want to append column names to the Data.

For example,

Brand	Product
1	1
1	2
2	3
2	4

To Be converted to 

Brand	Product
Brand 1	Product 1
Brand 1	Product 2
Brand 2	Product 3
Brand 2	Product 4

I'm not able to figure out a way. Any help would be appreciated!

[JosephSerpis · Accepted solution]

Hi @vinayR96 I mocked up a workflow that produces your output. Let me know what you think?

[meljaafari · Accepted solution]

Hi,

You can leverage the CrossTab and Transpose as a way to bring column headers to rows, concatenate the bring them back to columns.

The record ID at the start is what allows us to still identify every single row within your data.

Here is what the workflow based on your data looks like, and I have attached the sample workflow

I hope this helps,

Cheers,

Mo

[vinayR96]

Thanks Joseph! This is very helpful!

[vinayR96]

Thanks Mo! This is very helpful!