Help please

[sebasgj]

Hello,

I want to turn this

CLINICAS	REGIÓN	01-ene	02-ene	03-ene	04-ene
Dentix El Toreo	VDM	4	7	8	5
Dentix Lomas Verdes	VDM	1	5	9	8

Into this

DATE	CLINICAS	REGIÓN	PV
01-ene	Dentix El Toreo	VDM	4
02-ene	Dentix El Toreo	VDM	7
03-ene	Dentix El Toreo	VDM	8
04-ene	Dentix El Toreo	VDM	5
01-ene	Dentix Lomas Verdes	VDM	1
02-ene	Dentix Lomas Verdes	VDM	5
03-ene	Dentix Lomas Verdes	VDM	9
04-ene	Dentix Lomas Verdes	VDM	8

Can someone help me please?

Thanks

[MarqueeCrew]

@sebasgj,

Help is on the way!

[MarqueeCrew · Accepted solution]

@sebasgj,

A transpose tool followed by a select is the solution that you're searching for.  Attached is a sample.

Cheers,

Mark

[sebasgj]

Thank you @Marquecrew :D, it worked