+ Reply to Thread
Results 1 to 3 of 3

Re-formatting Data

  1. #1
    Registered User
    Join Date
    09-11-2019
    Location
    Leicester, England
    MS-Off Ver
    2017 for Mac
    Posts
    2

    Re-formatting Data

    Good Morning,

    I would really like some help with this problem if possible. I have been sent some excel data however it is formatted in a way that makes it incredibly difficult to sort.

    So currently we have three columns

    TXN Number, Purchase Date & Customer Name

    Then under each of these headings we have the following rows
    Which t-shirt colour would you like?
    Which t-shirt size would you like?

    Preferably after name I would like the row's to be moved over to the columns so it's TXN Number, Purchase Date, Customer Name, t-shirt colour & t-shirt size.

    The file is fairly big with a lot of information so what would be the easiest method of moving every 2nd & 3rd row after the customer name over to columns next to the name?

    Screenshot 2019-09-11 at 11.41.10.png

    Many thanks in advance for your help.
    Last edited by Tanwir; 09-11-2019 at 06:41 AM.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    5,734

    Re: Re-formatting Data

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    09-11-2019
    Location
    Leicester, England
    MS-Off Ver
    2017 for Mac
    Posts
    2

    Re: Re-formatting Data

    Hi,

    Please see attached the sample workbook of what I am trying to achieve.

    Hopefully somebody can help me out with this.

    Thanks,
    Tanwir
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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