Separate Data from two rows to four rows!!

[gokzee]

Hiiii,

Thanks for looking by..

i have attached an excel sheet.

i have a sheet named input..where i have a table.

i have made a pivot from this table in the pivot sheet.

my problem is i dont want the amounts h and i to come together

i want it separate as shown in the output required.

instead of two entries i will have four entries for example.

in my actual scenario i have many entries..but i have just put two entries in the sheet.

is there a way i can do this??

Many Thanks

Gokz

[aydeegee]

Hi Gokz

Using a helper column it seems to work (as attached)

Regards

Alastair