• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting unique value

Kindly help

  • Excel related

    Votes: 1 100.0%

  • Excel related

    Votes: 0 0.0%
  • Total voters
    1
R

Ravindra

Member
Dear All,

I have an urgent query as has been given below:-

There are 5 columns in excel and I need to place the records of 4 columns respectively are Print Date, Letter Type, Producer Id, and Issue Date these depend on the unique Vendor Number in horizontal. I have also given blank filed to place these records there. In a first record, I have consolidated the three rows records in to a single row into related fields. In a first record there is a Vendor Number – 60001197 and I consolidated the records of three records respectively related to columns Letter type, Producer Id, Issue Date and Print Date.

For better understanding, kindly see the attached file.
 

Attachments

  • doubt.xlsx
    11.2 KB · Views: 10
Hi, Ravindra!

There're no urgent queries, just queries. I assume that with 25 posts you've already gone thru what follows;
... if not, then better later than never:

How to get the Best Results at Chandoo.org
  • Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight.
  • If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days.
  • Check your posts regularly for answers. Login, then Click your User Name at the top of the page. That takes you to a screen where your posts are listed along with the date of the last reply.
Please Don't
  • Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out.
Regards!
 
I just want all the records to be placed as vertical wise. I will really appreciate your any kind of help in this concern.
Thanks......
 
Hi Ravindra,

Please see attached file. I used a helper column and (for now) every 'vendor nr.' occurence will give the same result. Let us know if this is acceptable :))
 

Attachments

  • doubt.xlsx
    49.4 KB · Views: 1
Here is a little modification. See attached file.
 

Attachments

  • doubt.xlsx
    54.2 KB · Views: 5
You must log in or register to reply here.
Back
Top