Create a Pivot table

Hello,

I do require a help.
Please find the attachment in which there are two sheets raw data and required format.

I want to apply pivot table to the raw data in such that results will be as mentioned in the second sheet ( Required format).

Please help

Thanks & Regards

NItin Shetty.

Hi Nitin,

I don't think you'll able to create a Pivot like that.

To Get THe Format you want you will want to create a helper column.

You can paste a conatenation formula in one Column lets say E. This formula will be in E2 =CONCATENATE(B2,C2,D2).

Once this is done you will have a new column with 3 values run together. It appears that you need only the unique combination of these values so next we will copy column E and paste special values into column F.

Now that you have pasted these values you will want to eliminate duplicates.

Highlight Column F then go to the Data tab. Remove duplicates. You now have only unique values

Now you have only the unique values that you wanted on your formatted page. Next you will need to separate these 3 strings out again.

In G2 put this formula =LEFT(F2, 6) and drag down to the last value of unique values.
In H2 put this formula =MID(F2,7, 5) and drag down to the last value of unique values.
In I2 put this formula =H2+0 and drag down to the last unique values. Now select column I:I and format as date. Copy and Paste as Value in place(same Column). THen delete columns H it is no longer needed.
In I2 put this formula =RIGHT(F2,LEN(F2) -11) and drag down to the last unique value.
Copy and Paste Column I's Values In Place (Same Column)

Now you should have the information you need. Copy and Paste Under your headers....

This process is fairly easy to automate with the macro recorder and a little editing. A Pivot Table is not needed.

Actual i add data daily to the master file.

Hence needed a pivot table so that whenever i refresh it it will give the data.