Creating a data set based on raw form

[bushpalaamarnat]

Hi Team,

This is part of data providing in a set format as follows

Brand

Sub-Brand

Variant

Material

Material Description

Presentation

Organisation

Region

Profit Center

Source

Invoice Category

Month

Year

Type

Out put

qwe23

XXX

XXX

XXX

XXXX

dfasds

sfa

fasdf

dfasd

dfas

asdfa

Jan

2017

MCF (£)

2000

qwe23

XXX

XXX

XXX

XXXX

dfasds

sfa

fasdf

dfasd

dfas

asdfa

Jan

2017

MCF (CU)

200

based on the raw data format which is attached.

could you please advise what is the better way to do this?

Any help is appreciated.

[Anonymous]

Hi Neelima,

I don't quite understand what you're looking to do. The .xlsx file you've provide only has the headers, with no data.

Can you please clarify your question?