Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Pivoting Dynamic rows into columns

Comment:

Original file we are getting ....... Item Period Amt P1 106 1000 P1 206 1500 P1 106 2000 P2 256 5800 P2 650 7500 My output should be like this Item 106 206 256 650 ............ P1 1000 1500 0 0 ............ P1 2000 0 0 0 P2 0 0 5800 7500 ............... ........... ........... ................ Hi all my requirement is quite tricky . ..its very urgent... i want to convert 1st file into as 2nd file........ i want to convert Period col values into columns and amount should be placed w.r.t Period value If corresponding amount is not available for Period then 0 should be enter for that period... and Items can be dynamically change.... means it can come P3,P4 etc....... Thanks Prakash

Batch Timer

grab DHCP IP and set as ...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am required to make a text file compressor/decompressor for a class I am taking. I am to use the run length algorithm. I have a few ideas on how to accomplish this, but wanted to run it by more se...

Summary: Not exactly, Razor I want the value in J2 to drop into column J of the NEW row I just created with the InsertRow macro. Taking from what you said, I've corrected it below, but that still doesn't tell ...

Summary: Are we playing "Who can post the longest message"? :-) Sorry Jeff, I'm afraid your Jack has you beat:-) I just wanted to point out a couple of things about two and three dimensional arrays: a) I ha...