Transform column to row

[AnGi]

hi guys

i have a file with this situation

Day	Name 1	Name 2	Name 3	Name 4	Name 5
Monday	Paul	Martin	John
Tuesday	Cris	Sebastian	Philippe	John	Ralf
Wednesday	Paul	Philippe
Thursday	Carl	Manuel	Alex	Andrew
Friday	Sebastian

and would like to have this

Monday	Tuesday	Wednesday	Thursday	Friday
Paul	Cris	Paul	Carl	Sebastian
Martin	Sebastian	Philippe	Manuel
John	Philippe		Alex
	John		Andrew
	Ralf

What's the best tool and hot have to configure it?

Thanks

[atcodedog05 · Accepted solution]

Hi @AnGi 

Here is how you can do it.

Workflow:

1. Using Day as key transpose all columns.

2. Using Name as key use day as name and value as value crosstabing it back to table.

3. Using select to order columns.

Hope this helps 🙂

[Hamder83]

Hi 

Maybe like this?