Results 1 to 3 of 3

Need help transposing data set against specific invoice number.

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2020
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    1

    Need help transposing data set against specific invoice number.

    I have a data table where I have a list of products against a particular invoice number. I need to reorganize the table such that the products are listed in columns along the invoice number instead of rows. Having it listed in rows results in duplication of the invoice number and is creating problems with analysis. I have attached a screenshot of the data table that I am referring to.

    Would appreciate any help regarding the matter.

    Note: Attached image is from a sample data. The actual database is too big for it to be done manually.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generate Invoice Number + Index Match data intry to invoice
    By Trish123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2020, 12:37 PM
  2. Choose Invoice Number from a userform combobox and copy data to invoice output
    By djemy1975* in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2016, 06:02 AM
  3. Copy and paste data from master based on a specific format based on Invoice number
    By anandnair1983 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2015, 06:32 AM
  4. Replies: 0
    Last Post: 09-28-2015, 06:32 AM
  5. Print Invoice by pulling info from database by selecting Invoice Number
    By Swapnil Panchal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 11:21 AM
  6. Saving Invoice where next time I open file the Invoice Number increases by 1
    By domgee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 03:03 PM
  7. Replies: 4
    Last Post: 11-04-2012, 12:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1