+ Reply to Thread
Results 1 to 3 of 3

reorder cell values

  1. #1
    Registered User
    Join Date
    08-03-2018
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    1

    Lightbulb reorder cell values

    Hi there community!

    I currently have a very long list with customer orders where the ordered SKU's are all listed per order on the same row.
    Our fulfillment partner's system however only allows 1 SKU per line.

    Is there any easy(ish) way to convert the list without the risk of too many mistakes sneaking in?

    Untitled.png


    Thanks guys!

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,880

    Re: reorder cell values

    Hello and welcome to the forum.

    Easiest way in my opinion would be through Power Query.

    Highlight A3:D5 > Data > From Table > OK > Transform > Select the order nr column > Unpivot Columns > Unpivot Other Columns > Home > Close & Load.

    See attachment.
    Attached Files Attached Files
    Last edited by 63falcondude; 08-03-2018 at 10:38 AM. Reason: Almost forgot to welcome!

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,880

    Re: reorder cell values

    You can also change the column names and filter out the rows with 0 right in the Power Query editor.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reorder Values Based on Importance
    By rjj920 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2018, 08:04 PM
  2. Reorder First Name and Last Name
    By hokieguy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-07-2014, 08:51 PM
  3. [SOLVED] Macro to reorder entries in a single cell
    By willi_42 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-13-2012, 12:04 PM
  4. Reorder elements a cell using arrays, split & join
    By k8_dog in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-12-2011, 01:58 PM
  5. How can I randomly reorder my values in my array?
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2008, 05:24 AM
  6. macro to reorder a cell.
    By DAKPluto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2008, 12:51 PM
  7. How can I reorder a CELL alphabetically in Excel
    By Chris in forum Excel General
    Replies: 3
    Last Post: 09-22-2005, 09:05 AM

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