Split a file

[#1]

Hello,

I have an Excel file with budget data and for each customer is there one line with

one column for each month. How do I load this file to get one record pro month?

This is the infile:

This is what I would like to get:

kindly

Håkan

[tamilarasu · Accepted solution]

Hi Håkan,

You can use cross table option to get the above result.

Data:

CrossTable(Month, Amount)
LOAD Customer,
Jan,
Feb,
Mar,
Apr
FROM
[Your Excel File]

(ooxml, embedded labels, table is Sheet1);

I have attached a sample file for your reference.

[#3]

Thanks for a very fast and correct answer.

kindly

Håkan