Columns to Rows

[#1]

Hi All,

I have a spreadsheet like below

Region	Month1	Month2	Month3	Month4
Region	Client	Client	Client	Client
Region	Client	Client	Client	Client

From this spreadsheet I would like to create a single table with the following Structure:

Region	Months	Clients
Region	Month1	Client
Region	Month2	Client
Region	Month3	Client
Region	Month4	Client

The main problem I am facing is getting the month columns to rows into a single Months column.

Any suggestions would be appreciated?

Thank you,

GJ

[lironbaram · Accepted solution]

hi

try this one hope it helps you

[rohit214]

HI

try this

crosstable(Months,Clients)

load

Regoin,

Month1,

Month2,

.

.

.

.

.

.

from

xyz.qvd;

Hope it helps you

thanks

rohit

[#4]

Thanks Liron and Rohit. Both examples worked perfectly.

Regards GJ.