Combining data

[SCK]

Hi all.. I need help in combining and concatenating data. I have the below input and desired output. Basically, what is happening is the data in column A is concatenating with the headers from column B onwards and hence, we are left with. Please help.

Input:

Data	Book	Games	Events
Sam	4	7	8
Rachel	5	5	8
Nathan	2	6	6
Anthony	7	4	6

Output:

Data	Value
Book - Sam	4
Games - Sam	7
Events - Sam	8
Book - Rachel	5
Games - Rachel	5
Events - Rachel	8
Book - Nathan	2
Games - Nathan	6
Events - Nathan	6
Book - Anthony	7
Games - Anthony	4
Events - Anthony	6

[AkimasaKajitani · Accepted solution]

Hi @SCK 

This is my solution for you.

1. Transpose the each field

2. Change the data size of "Data" Field to update

3. Combine "Data" and "Name" field

[Qiu · Accepted solution]

@SCK 
Almost similar with @AkimasaKajitani 😀

[grazitti_sapna · Accepted solution]

Hi @SCK,

Here is my take on this problem.

I hope it helps.