Pivottable Creation help

**naveen.narayan** · 05-24-2010, 06:28 AM

Hi Gurus,

I have a master Ship list and one recieve file which contains packets recieved from the ship on each dates.and a sent list which includes packets sent to ship on each data.
i need to create a pivottable which can show for each ship and for a date range which are the received packets and send packets.

Thanks.

Naveen

**teylyn** · 05-24-2010, 07:23 AM

Hello naveen,

welcome to the forum.

for a pivot table, you need a different data structure as the source.

See attached for an example.

I'm not quite clear what you want to summarise and what your "date range" might be.

Maybe you can clarify.

cheers,

**naveen.narayan** · 05-24-2010, 11:29 AM

Hi,

The packet is not the data packet, this is a ZIP file that we received from the
SHIP So inturn the server will send another ZIP file series that will say confirm the
packet received.

some thing lilke this

KAMAL

DATE 01/02/2010 03/02/2010
PACKET SENT PVIRE1000018.ZIP PVIRE1000019.ZIP

DATE 02/02/2010 04/02/2010
PACKET SENT POIRE1000042 POIRE1000043

QUEEN VICTORIA

DATE 01/02/2010 03/02/2010
PACKET SENT PVVICE1000018.ZIP PVVIC1000019.ZIP

DATE 02/02/2010 04/02/2010
PACKET SENT POVIC1000042 POVIC1000043

**teylyn** · 05-24-2010, 05:38 PM

Please don't quote whole posts.

If you want to build a pivot table, your data must be in a tabular format with no blank rows, no blank columns, and all data fields filled in, especially identifying fields.

I'm not sure what you mean with the last post. How does that relate to the file you attached in your initial question?

**naveen.narayan** · 05-24-2010, 08:53 PM

Hi ,

As I told you in the first example , I have three files one with Master Details of Ship
One with Send Packet.zip file with date field and thired Received Packet.Zip with date filed. So multiple range . hope you understood.

Thanks
Naveen

**teylyn** · 05-24-2010, 08:58 PM

Again, please don't quote whole posts.

In my first reply I've given you the data structure you need to create a pivot table from your data.

What is your question?

**naveen.narayan** · 05-24-2010, 10:16 PM

hi ,

I am attaching the sample output i need from my consolidating two excel files

1. Sent Packets as per date
2. Received Packets as per date

Thanks,
Naveen