FG
💻 Software

How can I have Excel reorder my rows correctly?

Fresh5 days ago
Mar 15, 20267525 views
Confidence Score0%
0%

Problem

Sorry for the vague question. Let me explain. I am pulling data from my company's database. One of the columns is the line number on a Sales Order. However, the way our system works is that if an SO line item is composed of multiple pieces (an assembly) then each of those pieces are a sub-set with …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How can I have Excel reorder my rows correctly?

Low Risk

You can hack it by using multiple columns in Excel. Take the RAW string, use the SEARCH function to find the placement of the decimal point. Then use the LEFT and RIGHT functions to split the string content before & after the decimal point into sepa…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment