Convert date rows into date columns

[valpassos]

Hi folks,

I have a file with this structure (ignore dummy values):

And I simply want to convert the Date rows into various columns (one column for each year-month) because I have the requirement to see the data in a table with this format. I cannot use Pivot Table because pivot table does an aggregation (the Totals rows) that, for this purpose, is not accurate.

I have tried the Generic Load but I'm not getting anything. I have to use a resident and preceding load with it and it keeps saying "Table 'myGenericTable' not found"

Any help?

Thanks!

Lisa

[valpassos]

Hi Shahbaz,

Yes, the %s are pre-calculated in the data. So, they are fixed. I just want to directly read them in a pivot table.

Unfortunately I don't have any sample 😕 But that screenshot shows what my issue is with the pivot table.

Thanks,

Lisa

[JordyWegman · Accepted solution]

That is because you have two classes. Can't you delete the first?

[valpassos]

Hi Jordy,

Deleting a class was what I ended up doing!

Didn't realise it was 'that' simple.

Thanks!

Lisa